Hi All,
I have a worksheet which has a button.Now I want to disable right click on that button so that users cannot change or view the macro by right clicking the button.
Appreciate your help!
Hi All,
I have a worksheet which has a button.Now I want to disable right click on that button so that users cannot change or view the macro by right clicking the button.
Appreciate your help!
You can protect your vba code with password so that even if the user right clicks the button he would not be able to view / change the code unless he knows password.
I have already protected the code with pass>word but still I am able to right click on the button. Can you please tell me how you applied the protection on the sheet so that I acan match with my steps? I have done it from VBE-->Tool-->VBA Project Properties -->Protection tab
You will be able to right click even if the code is protected but cannot view the code. Your worry is that user would be able to see the code if right clicked so I suggested protecting macro so that user will not be able to view or change the code. They can still right click on the button for other options.
you could protect the worksheet
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks