Excel 2007

[Nigel]

Hi All
I have just upgraded to xl2007, although I run xl2003 on another PC. All of
my code is written for 2003, and for the moment will continue to be.

Most of my code is fine, but in xl2007 I wish to disable the Ribbons, as my
menu code provides the UI. Is there a simple switch to turn these off, or
do I need to store the active ribbons as I would active menubars in xl2003?
Also are Ribbons stored in an .xlb file or some other method.

Cheers

 

[Jon Peltier]

The ribbons are completely different than commandbars and menus. They are
pretty much incompatible, although Excel 2007 is able to take some of the
custom commandbar and menu items and place them on a separate Add-Ins
ribbon. This is less useful than it seems, even if it works as intended.

To find information, Google for Excel and RibbonX.

- Jon