Disable items on ribbon using VBA

  • Thread starter Thread starter Cresta
  • Start date Start date
C

Cresta

Hello again

How do I enable or disable a button or group on the ribbon using VBA.
(Are there any decent web sites that reference this). An example would be
the "Unprotect Sheet" button on the "Review" tab.

and the same for the menu item - "Home", "Format", "Unprotect Sheet"

I have a list of all the PolicyID's but am unable to make it happen.

Help Please
 
Back
Top