Disable the 'Unprotect Sheet & Workbook" buttons...

[Marra71]

Hi all,

Does anybody have a code for disabling the 'Unprotect Sheet and Workbook" buttons in 2013? I have a large amount of sheets which I am protecting by VBA with a password entered from a Userform which is run from a key stroke, and I'd like to stop users trying to unlock from the buttons.

Thanks in advance, Martin.

 

[bugmonsta]

To do this you will need to disable/hide the item... the best place I have found with this information is Ron de Bruins website:

Ribbon and Quick Access Toolbar pages