Hi,
Can anyone show me how to disable / enable the 'Protect Workbook' button using VBA, the button is located under the 'Review' menu option on the ribbon bar.
I've looked at the official Microsoft Control Names list and I believe the one I'm trying to toggle is the following:
Control Name: ReviewProtectWorkbook
Ordering: 820
PolicyID: 894
Any VBA help or pointing me in the right direction would be much appreciated ... this ribbon stuff is obviously trickier than I thought!
Cheers
Don
Can anyone show me how to disable / enable the 'Protect Workbook' button using VBA, the button is located under the 'Review' menu option on the ribbon bar.
I've looked at the official Microsoft Control Names list and I believe the one I'm trying to toggle is the following:
Control Name: ReviewProtectWorkbook
Ordering: 820
PolicyID: 894
Any VBA help or pointing me in the right direction would be much appreciated ... this ribbon stuff is obviously trickier than I thought!
Cheers
Don