assign button on QAT to macro

[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

[StuartR]

I can see macros in all my global templates in that window (Word 2010)

[HansV]

I'm using Word 2010 and I do see macros from global templates (add-ins):

S00056.png

[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

[HansV]

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

[StuartR]

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

So did I

[HansV]

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

[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

[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.

[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...

[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

[StuartR]

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.

[HansV]

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

[StuartR]

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

[HansV]

How weird - but thanks for testing!

[stuck]

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

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

Ken

[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

[stuck]

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

Ken

[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 to Kim

Ken

[kdock]

Glad to help and thanks for the !!