Excel 2010 VBA - Disable Ribbon Button?

[DAmoss]

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

 

[kjv1611]

Best I recall, you can't program the ribbon from VBA, but rather yo have to use C# or C++ I forget..

And are you wanting to control it on a per workbook basis or per user basis or what? I'm not terribly sure it's possible, or at least not very easy, on a per workbook basis.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57