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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Cresta" wrote in message ...
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