Excel 2007 : Customizing the ribbon/menu items.

Our application is currently written using Office XP (Excel 2002). When our tool is run, we modify the menu items (add and remove some of them). For example, we remove some like the ones that allow users to Insert rows.

We also have code to add our own menu items.

In Excel 2007, is there a way using code to disable the menu items and to create our own?

Also, in Excel 2007, is there a way using code to disable/hide some of the options on the ribbons? Also, can we add our own menu items along with ribbon commands? How can this be done using code?

Hello,

In Excel 2007, is there a way using code to disable/hide some of the options on the ribbons?

You can use XML and VBA code to modify or create custom controls in the Ribbon.


This XML code desactivate "CellFillColorPicker" button :
enabled attribute to false, desactivate the button.

Please Login or Register  to view this content.

Commands parameters have to be placed at the begin of xml file, before the line :
ribbon startFromScratch="boolean".
This action desactivate the button in "TabHome" and mini toolbar (contextual bar).

This is a simple example. there many other options : repurpose commands, conditionnals desactivations ....

Also, can we add our own menu items along with ribbon commands? How can this be done using code?

another reference to custom your ribbon :

http://www.oaltd.co.uk/Spreads/Excel...ogRef_ch14.pdf



Regards
michel