Protection of Command Buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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????
 
You must log in or register to reply here.

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

Protecting Command Buttons 5
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Workbook protection 1
macro protection 4
How to use multiple command button to copy user form data to multiple worksheet 0
Command Button and macro 4
Command Buttons 3
Can't use protection options 1

Back
Top