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" <(E-Mail Removed)> wrote in message news:702047FC-876F-4A0A-B277-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:702047FC-876F-4A0A-B277-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:441A46C4-801B-42CE-8840-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:702047FC-876F-4A0A-B277-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message news:441A46C4-801B-42CE-8840-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:702047FC-876F-4A0A-B277-(E-Mail Removed)...
> >> > 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.
> >> >
> >>
>