Buttons won't work

[KimR.Hammel]

Two questions:

1. When I protect a sheet, my buttons no longer activate. This is true even
though I've gone to "Format Control" and then deselected "Lock" for each
button

2. Under Tools>Options I've made many changes including: eliminate row and
column headers and formula bar. I've also eliminated all of the toolbars.
When my user opens the file on their computer, will these changes still be in
effect, or will their defaults come up. If so, can I force this Worksheet to
always open with the same Excel formatting?

Thanks,
--Kim

[Nigel]

1. Buttons should still work when the sheet is portected, unless the code
linked to the button is acting on protected data.

2. The settings are stored in the users .xlb file and are persistent,
normally you must save the settings before you change them and restore them
afterwards. Be prepared to deal with the situation when a system crashes or
Excel terminates abnormally, the settings will not be restored in this case.
Some applications store the settings in an external file so these can be
recovered later.


--
Cheers
Nigel



"KimR.Hammel" <KimRHammel@discussions.microsoft.com> wrote in message
news:51DB5251-A1BB-4E54-98B0-CB1924187213@microsoft.com...
> Two questions:
>
> 1. When I protect a sheet, my buttons no longer activate. This is true
even
> though I've gone to "Format Control" and then deselected "Lock" for each
> button
>
> 2. Under Tools>Options I've made many changes including: eliminate row
and
> column headers and formula bar. I've also eliminated all of the toolbars.
> When my user opens the file on their computer, will these changes still be
in
> effect, or will their defaults come up. If so, can I force this Worksheet
to
> always open with the same Excel formatting?
>
> Thanks,
> --Kim