Disable items on ribbon using VBA
 

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

Disable items on ribbon using VBA
 

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

Disable items on ribbon using VBA
 

Excellent thank you.

"Ron de Bruin" wrote:

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