PDA

View Full Version : Disable Protect/Unprotect button on the ribbon



Juriemagic
06-05-2015, 03:42 AM
Hi there!,

There are some examples of how to disable the "protect sheet" button on the Excel ribbon, but have not found anything on the topic for Excel 2013. I have a workbook which contains several sheets. One of the sheets protect and un-protect via VBA. When certain selections are made, VBA will unprotect the sheet, wait for the input and protect it again. No passwords are involved here. I was wondering if I could prevent users from manually clicking "Un-protect sheet" button, by having the button dis-abled via VBA. Can this be done?. Please, all and any help will be greatly appreciated!. Thank you people!

Kenneth Hobs
06-06-2015, 06:41 PM
See: http://www.rondebruin.nl/win/section2.htm

Juriemagic
06-07-2015, 10:23 PM
Hi Kenneth,

I have already found this site and have started looking at it...wow, looks kind of involved. Thanx for responding, I do appreciate that..have a blessed day..