In previous posts we learned to record a macro and create a shortcut key and custom button for the macro. In this post we will learn how to distribute the macro to others, along with the shortcut and button.
In the previous examples we saved everything in the Normal template, which is the default template when you record macros and custom shortcuts.
However, you can specify a different template when saving macros and other customizations. You can also move your macros to a new template later. This is what we will do in this post.
First we need to create a new template to store the macros and customizations.
We do this by making a new document and saving it as a ‘Macro-Enabled Template’ or .dotm file:
When you change the file time to ‘.dotm’ Word automatically defaults to it’s ‘Templates’ folder to save the template. To make it easier to find later, you can just change this to a different folder or to the desktop.
To copy the custom macros we made into this new template, click the ‘View’ tab, ‘Macros’ drop-down, ‘View Macros’:
Here is the list of macros we created in a previous post. Notice that the macros are saved in the ‘Normal.dotm’ template.
To copy these macros into our ‘My Custom Macros’ template, click on the ‘Organizer’ button:
The list of macros in the Normal template appear on the right side of the screen. Notice that ‘NewMacros’ appears in the ‘Normal.dotm’ template, not the individual macros. When we copy the macros from the Normal template, all of the macros in this group will be copied over.
Make sure that ‘My Custom Macros’ template is selected on the left side and click ‘Copy.’
Now go back to ‘View Macros.’ Make sure that ‘My Custom Macros’ template is the active document and that it is also selected in the ‘Macro’ field. You should see our three macros now appear on the list:
Repeat the shortcut key that we did before, except this time make sure that ‘My Custom Macros’ template is the active document and you select it instead of the Normal.dotm. Also be sure to select the macro that is contained in the ‘My Custom Macros’ template. This may appear as ‘Template Project’ instead of ‘Normal’
And the same for the Quick Access Toolbar:
‘My Custom Macros’ template can now be copied to other computers and shared with colleagues.
To access the the macros and customizations contained in the template, we attach the template when we open Word. To do this go to File/Options/Addins. Select ‘Templates’ in the ‘Manage’ field and click ‘Go…’.
We want to make ‘My Custom Macros’ a global template so click the ‘Add’ button next to the ‘Global’ templates box:
Browse and find ‘My Custom Macros’ template. It now appears on the list and is checked:
When you first attach the template you may be prompted to enable the macros:
To avoid seeing this warning you can make the templated ‘Trusted’ or save in a trusted location, like the ‘Startup’ Folder.
If the template is saved in Word’s Startup folder, it will also attach automatically whenever you start Word.