Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2007

Tip: Looking for answers? Try searching our database.

Adding entries to 2007 QAT

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 31 Jul 2007 11:25 GMT
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 - 01 Aug 2007 02:16 GMT
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?

Signature

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

Ed - 02 Aug 2007 02:04 GMT
>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
> Ed was telling us:
> Ed nous racontait que :
[quoted text clipped - 10 lines]
> How would the macro know which macros to add?
> What would be the logic to use in the code?
Jean-Guy Marcil - 02 Aug 2007 03:07 GMT
Ed was telling us:
Ed nous racontait que :

>> You want a macro to add buttons and their assigned macros to the QAT?
>
[quoted text clipped - 13 lines]
> 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?

Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.