ActiveX buttons not working when sheet is protected

New Contributor

Hello everyone, 


I am having some difficulty with the ActiveX buttons. I created three, refresh, pending and completed. I want to protect the sheet so others don't accidently click on anything except those three buttons. Once I protect the sheet a Run-time error '1004': pops up. I click debug and it takes me to the code page and it highlights a line. It does the same thing ever time I click on any of the buttons. Any recommendations? I am attaching screen shots.  

0 Replies