How can I make macros execute on a protected sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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"
 
Back
Top