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

[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!

 

[Tim Zych]

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.