ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 (https://www.excelbanter.com/excel-programming/398853-excel-2007-a.html)

Nigel[_2_]

Excel 2007
 
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

--
------------
Nigel



Jon Peltier

Excel 2007
 
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

--
------------
Nigel





All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com