assign button on QAT to macro

User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

assign button on QAT to macro

Post by stuck »

I have a macro that is stored in a global .dot file, i.e. in a template that always loads because there is a shortcut to the file held in the \Office12\STARTUP folder.

If I click Customise QAT and choose More Commands and then filter for just 'Macros' I don't see any of the macros in the global template. Presumably because that is looking in normal.dot. I don't want to move my macro to normal because I want it to be available to other users who also access the global template.

How do I assign my macro to a button on the QAT?

Ken

User avatar
StuartR
Administrator
Posts: 12650
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: assign button on QAT to macro

Post by StuartR »

I can see macros in all my global templates in that window (Word 2010)
You do not have the required permissions to view the files attached to this post.
StuartR


User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: assign button on QAT to macro

Post by HansV »

I'm using Word 2010 and I do see macros from global templates (add-ins):
S00056.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: assign button on QAT to macro

Post by stuck »

I'm using 2007, would that make a difference?

I wondered if it was something to do with trusted locations but if it is I've not figured it out yet.

Ken

User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: assign button on QAT to macro

Post by HansV »

I stored the add-in in my own Startup folder (in my user profile), not in the program folder.
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12650
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: assign button on QAT to macro

Post by StuartR »

HansV wrote:I stored the add-in in my own Startup folder (in my user profile), not in the program folder.
So did I
StuartR


User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: assign button on QAT to macro

Post by HansV »

Ken, can you run the macros from the add-in from the Macros dialog (Alt+F8)?
Best wishes,
Hans

User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: assign button on QAT to macro

Post by stuck »

If I reset my file locations for Word, back to their defaults, i.e. so that my setup looks in the relevant folders within my profile for its normal.dotm and the global.dotm then I only see macros stored in normal.dotm when I try to customise the QAT. However, the macro in the global.dotm is available via the Macro dialog on the Developer tab and it does what it is supposed to do.

The same is true if I restore my file location customisations, i.e. point to a central template repository on the network and load the global template via a shortcut in the Program Files startup folder. I can only see macros in normal and put them on the QAT but macros in the global template are available via the Developer tab and they do work.

Which suggests this limitation on which macros can assigned to the QAT is a Word 2007 thing does it not?

Ken

User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: assign button on QAT to macro

Post by HansV »

I'd be *very* surprised if it wasn't possible to add macros from add-ins (global templates) to the Quick Access Toolbar in Word 2007, but I can't test it - no PCs with Office 2007 within reach.
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12650
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: assign button on QAT to macro

Post by StuartR »

Give me a few minutes and I will wind up an old laptop that runs Office 2007 and test this...

10 minutes later
... an old and rather slow laptop...
StuartR


User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: assign button on QAT to macro

Post by stuck »

In case it is relevant...

When I record a macro the only choices I have of where to store it are in the open doc or in normal, my global template isn't offered as a repository.

Ken

User avatar
StuartR
Administrator
Posts: 12650
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: assign button on QAT to macro

Post by StuartR »

stuck wrote:In case it is relevant...

When I record a macro the only choices I have of where to store it are in the open doc or in normal, my global template isn't offered as a repository.

Ken
That is normal, unless you have the global template open at the time.
StuartR


User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: assign button on QAT to macro

Post by HansV »

That is 'normal' behaviour - recording in the global template would only be possible if you have opened it as a document.
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12650
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: assign button on QAT to macro

Post by StuartR »

My laptop running Word 2007 cannot add Macros from global templates to the quick access toolbar.
StuartR


User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: assign button on QAT to macro

Post by HansV »

How weird - but thanks for testing!
Best wishes,
Hans

User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: assign button on QAT to macro

Post by stuck »

Weird it may be but I'm not surprised, Word 2007 was clearly only a beta for 2010 :evilgrin:

Thank you for your efforts, I will have to live with is 'feature'.

Ken

User avatar
kdock
5StarLounger
Posts: 722
Joined: 21 Aug 2011, 21:01
Location: The beautiful hills of Western North Carolina

Re: assign button on QAT to macro

Post by kdock »

You can assign macros in Word 2007, but you have to open the global template first. Then the macros appear. I can then assign macros to the QAT, close the global template, reload it... and the macros work.

Best, Kim
"Hmm. What does this button do?" Said everyone before being ejected from a car, blown up, or deleting all the data from the mainframe.

User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: assign button on QAT to macro

Post by stuck »

Sounds interesting. I'll try that first thing Monday and report back.

Ken

User avatar
stuck
Panoramic Lounger
Posts: 8225
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: assign button on QAT to macro

Post by stuck »

Reporting back...

YES! If I open the global template first, all the macros it contains are then available when I come to Customise the QAT.

A :chocciebar: to Kim :thankyou:

Ken

User avatar
kdock
5StarLounger
Posts: 722
Joined: 21 Aug 2011, 21:01
Location: The beautiful hills of Western North Carolina

Re: assign button on QAT to macro

Post by kdock »

Glad to help and thanks for the :chocciebar: !!
"Hmm. What does this button do?" Said everyone before being ejected from a car, blown up, or deleting all the data from the mainframe.