Leading the way in Microsoft Office Development

You can either put your macros in the global template “Normal.dot” although this is the quickest and easiest I would not recommend it.

Your Normal.dot can have a tendency to corrupt and is also a haven for viruses.

You should put your macros in another template “MyMacros.dot”.

To ensure your macro are always available you can save this template in your start up folder. (File > New) click Templates, click OK and save to your Start up folder.

Quit and restart to ensure that it’s a global template. Go into the VBA editor and then copy your macros across remembering to save the template before quiting

When recording a macro you cannot use the mouse for certain operations, especially selecting text and moving around in a paragraph or table. It is important that you are able to use the keyboard for the operations normally done by the mouse

If an attached template is not the Normal template and you wish to call a procedure in the Normal template then you must add a reference to the calling Project

Step 4 - Things to Remember