Code the Quick Access Toolbar?

[XP]

In XL 2007, is there an object model for the QAT and can it be coded and
modified on the fly?

If so, could someone post some example code and/or links to some helpful web
pages?

Thanks so much in advance.

 

[Ron de Bruin]

With RibbonX you can change your QAT but you must
use <ribbon startFromScratch="true"> first if you want that.

<ribbon startFromScratch="true">
This will hide most ribbbon tabs and the QAT and most controls in the Office Button menu

Tell me what you really want maybe there is a easier option.
If you want a menu on the QAT see this example
http://www.rondebruin.nl/qat.htm

 

[XP]

Hi Ron,

I was thinking of just adding a custom button on the QAT that would call a
program (in a file that runs hidden) that would in turn open a custom menu or
custom shortcut menu.

I was thinking of a program that could run auto when a file is opened, and
automatically install the custom button. User could then have certain macros
available when XL is opened...is that do-able?

 

[Ron de Bruin]

Why not add RibbonX to the workbook that change your ribbon
I have examples here
http://www.rondebruin.nl/ribbon.htm

If you need help post back

 

[XP]

Okay; thanks Ron!

Why not add RibbonX to the workbook that change your ribbon
I have examples here
http://www.rondebruin.nl/ribbon.htm

If you need help post back