How can I make macros execute on a protected sheet?

[Guest]

I have several command buttons attached to macros to enlarge or reduce the
size of embedded charts. When I protect the sheet, the macros will not
execute. Is there a way to protect the sheet and still enable the macros?

 

[JGeniti]

In your macro you could just add a line of code at the begining to
unprotect the sheet and then at the end of the code you can protect the
sheet again.

activesheet.unprotect
- macro code
activesheet.protect

if you have the sheet passwork protected you will need to add the
password at the end

activesheet.unprotect "password"

 

[philcud]

ActiveSheet.Unprotect Password:="XXX"