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" wrote in message
...
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 ToolsOptions 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