Adding entries to 2007 QAT

[Ed]

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 Marcil]

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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Ed]

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]

Ed was telling us:
Ed nous racontait que :

=================================
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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org