Macro (assigned to button) doens't work when sheet is protected

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I have a worksheet with some cumbersome formulae that I
wish to hide/lock/protect. I am able to do this, however
when I protect the sheet it seems to disable the macros I
have assigned to buttons in the worksheet. The macros are
essential. Can I have both things (hidden/protected cells
and functional macro buttons) working at the same time?
Please say yes...

Thanks!
 
Just set the Locked property to False and it should be fine.
For ActiveX buttons, this is settable in properties. Or right click in
design mode -> Format control -> Protection tab, uncheck Locked
For Forms buttons right click -> Format control -> Protection tab, uncheck
Locked.
 
Back
Top