Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A cross-version approach consists of two files. First is a Classic Excel
(i.e., 2000 through 2003) add-in, which does all the work, and detects the version of Excel. If the version of Excel is Classic, it builds the menus and commandbars as before. If the version is Excel 12, it opens the second file. The second file is an Excel 2007 add-in (not installed as an add-in by the way) with the XML code for the RibbonX modifications as well as the code that catches ribbon clicks and runs the appropriate command in the Classic add-in. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maury Markowitz" wrote in message ... On Jun 20, 8:05 am, "Jim Rech" wrote: The Quick Access Toolbar (QAT) was provided by MS for end users to put their own custom/favorite items in easy reach. MS did not intend for developers to use it themselves and made it almost impossible to do so. So the way to proceed as a developer is to learn RibbonX. But am I right to assume that RibbonX does not work under older versions? Is there any cross-version system that works well? Maury |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making Application.CommandBars.ExecuteMso method work in 2007 | Excel Programming | |||
Excel 2007 - Personnal CommandBars | Excel Programming | |||
CommandBars vs CommandBars(1).Controls | Excel Programming | |||
Commandbars | Excel Programming |