| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Items at runtime in the Ribbon ComboBox | Excel Programming | |||
| merging an excel 2007 ribbon items into exisitng classic excel too | Excel Programming | |||
| Change image for Ribbon items | Excel Programming | |||
| Is is possible to disable certain menu items | Excel Programming | |||
| Disable menu items with VBA | Excel Programming | |||
Hybrid Mode
