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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba solution for protection 3
Macros and protect sheet 4
Solver Compiler issue 2
Assign Macro with Hidden Sheet 4
assign button for color 9
Protect Sheet Macro 1
Expanding beyond "Very Hidden" 1
Excel Move or Copy Stopped Working? 0

Back
Top