LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default CommandBars in 2007?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making Application.CommandBars.ExecuteMso method work in 2007 JeffreyW Excel Programming 7 December 11th 07 09:01 PM
Excel 2007 - Personnal CommandBars Lucky[_5_] Excel Programming 4 March 12th 07 11:57 AM
CommandBars vs CommandBars(1).Controls Sean Excel Programming 3 April 3rd 06 01:34 PM
Commandbars PosseJohn Excel Programming 1 December 16th 05 05:51 PM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"