Protection of Command Buttons

[Dan Sweetwood]

Hello Everyone

I have an Excel spreadsheet that is created as command buttons are pressed and data is downloaded from a file that originates from a cash register. The issue is that the owner wants to protect the sheet and since the restaurant is closed two days a week he wants each month to lock those command buttons for those days each month. I can protect the command button from being editied but I can not stop it from running the macro. Any ideas how to lock it? Your assistance is greatly appreciated

Dan

 

[Dave Peterson]

You could use code and set the button to .enabled = false

(or even .visible = false)

Or you could have your code check the worksheet's protection. If it's
protected, issue a warning message and get the heck out????