Adding entries to 2007 QAT

Hoping that VBAwould record my steps, I added one of my macros to an icon
that would sit in the 2007 Quick Access Toolbar. I got the icon in place,
but none of my steps were recorded. Does anyone know the VBA code (in
general) that will allow me to add different macros to the QAT?

Ed (in Virginia)

Jean-Guy
Tue Jul 31 20:16:48 CDT 2007

Ed was telling us:
Ed nous racontait que :

> Hoping that VBAwould record my steps, I added one of my macros to an
> icon that would sit in the 2007 Quick Access Toolbar. I got the icon
> in place, but none of my steps were recorded. Does anyone know the
> VBA code (in general) that will allow me to add different macros to
> the QAT?
> Ed (in Virginia)

You want a macro to add buttons and their assigned macros to the QAT?

How would the macro know which macros to add?
What would be the logic to use in the code?

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Ed
Wed Aug 01 20:04:05 CDT 2007

>You want a macro to add buttons and their assigned macros to the QAT?

>How would the macro know which macros to add?
>What would be the logic to use in the code?
=================================
I want to assign one of the macro to a button, and allow others in the
office to do the same. I can do it 'by the numbers.' They won't know how. If
I can just give them a button to push and a list of macros they might want
to assign to a button, they can then do it themselves.

I don't know the 'code,' so I just want Word to record the steps that I take
to assign a selected macro to the QAT. Once I know the basic code, I can
handle the rest via variables.

(Recording macros is a standard way to 'discover' the VBA code needed to
accomplish a certain task. My frustration is that Word won't record any code
for the project I am attempting.)

Ed
"Jean-Guy Marcil" <DontEvenTry@NoSpam> wrote in message
news:O%23Bkpm90HHA.4928@TK2MSFTNGP03.phx.gbl...
> Ed was telling us:
> Ed nous racontait que :
>
>> Hoping that VBAwould record my steps, I added one of my macros to an
>> icon that would sit in the 2007 Quick Access Toolbar. I got the icon
>> in place, but none of my steps were recorded. Does anyone know the
>> VBA code (in general) that will allow me to add different macros to
>> the QAT?
>> Ed (in Virginia)
>
> You want a macro to add buttons and their assigned macros to the QAT?
>
> How would the macro know which macros to add?
> What would be the logic to use in the code?
>
> --
>
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>

Jean-Guy
Wed Aug 01 21:07:35 CDT 2007

Ed was telling us:
Ed nous racontait que :

>> You want a macro to add buttons and their assigned macros to the QAT?
>
>> How would the macro know which macros to add?
>> What would be the logic to use in the code?
> =================================
> I want to assign one of the macro to a button, and allow others in the
> office to do the same. I can do it 'by the numbers.' They won't know
> how. If I can just give them a button to push and a list of macros
> they might want to assign to a button, they can then do it themselves.
>
> I don't know the 'code,' so I just want Word to record the steps that
> I take to assign a selected macro to the QAT. Once I know the basic
> code, I can handle the rest via variables.
>
> (Recording macros is a standard way to 'discover' the VBA code needed
> to accomplish a certain task. My frustration is that Word won't
> record any code for the project I am attempting.)

Many operations are not recorded by the macro recorder, especially when
handling macros themselves while recording.

Also, if I understand things correctly, the QAT is part of the Ribbon, and
the Ribbon cannot be customize with VBA, you need XML for that.

But, adding macros to the QAT is so trivial, I do not believe your users
need a macro to do that for them. It would be easy to give them a one page
document to show them how if they cannot follow verbal instructions... no?


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org