Disable Protect/Unprotect button on the ribbon

[Juriemagic]

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]

See: http://www.rondebruin.nl/win/section2.htm

[Juriemagic]

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..