Command buttons in Excel
 

Hi

I guess this is a setting in Tools Options View, where the "objects"
section choices are different from one user/system to another. The tools
options settings is a confusing mixture of file preferences and user
preferences.

Just guessing. If I'm right you may try to override this setting with code
in the Open event; macros seem to be enabled.

Best wishes Harald

"tbigland" skrev i melding
...
I have an excel workbook which used buttons attached to macros to sort for
specific items. Normally it works perfectly but as I work in a school and
a
number of different members of staff access the workbook during the day I
have found a strange error which I don't know how to overcome.

The buttons sit in the top row and the top three rows are frozen so
scrolling can take place and still show all of the buttons. Great people
can
click on a command button and the set or group can be displayed and data
can
be entered. The problem is that on opening the workbook all of the command
buttons have disappeared. This is not always the case and if the workbook
is
opened on another computer on the network it sometimes has the buttons and
sometimes not. If the file is saved then it appears that there is no way
to
recaver the buttons. It is not critical as we have back up copies but it
has
happened on a number of occasions and is a nuisance having to re-enter
data.

Does anyone know why this is happening and how to either stop it happening
or how to get the buttons back? All of the macros are present for each
button
and the button name is also present as when viewing the macros in Visual
Basic.