Custom controls disappear when user opens file

FrigidDigit

Board Regular
Joined
May 10, 2005
Messages
203
Hi All

A cursory search of the web has not provided any answers so I thought I'd turn to the group for a quick answer.

I have a customised invoice template containing large amounts of VBA code as well as several custom controls e.g. command buttons. I have distributed this template to about 8 users, 6 of which have used the template without a single problem. However, when the other 2 users open the file, the command buttons seem to have disappeared! What I find strange is that both of these users used previous versions of the template (which had only minor differences in terms of command buttons) without a problem. I have tried to determine whether it could be the Excel version that they are using but both use the same version of Excel as I do (2003).

Any ideas?

Thanks!
Frigid Digit
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Hi

If you mean whether the sheet is in design mode when I open it no its not. Toggling design mode on/off makes no difference.

Or if you mean that I perhaps sent the worksheet in design mode, that could be possible.

Thanks for the response!
 
Upvote 0

Forum statistics

Threads
1,224,878
Messages
6,181,529
Members
453,053
Latest member
DavidKele

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top