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.

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

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" wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

Okay; thanks Ron!

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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