Disable items on ribbon using VBA

[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

 

[Ron de Bruin]

Hi Cresta

See point 2 for only RibbonX

See point 3 for a example file to do it with VBA

on this page
http://www.rondebruin.nl/ribbon.htm

 

[Cresta]

Excellent thank you.

Hi Cresta

See point 2 for only RibbonX

See point 3 for a example file to do it with VBA

on this page
http://www.rondebruin.nl/ribbon.htm