Protecting Macros in the Normal Template

by Allen Wyatt
(last updated June 29, 2019)

On Brett's company's network, the Normal template is periodically updated, automatically, based on whatever it is that his IT department does. The problem is, the Normal template contains Brett's macros that he's developed, which means they are overwritten. He wonders if there is a way to make sure that his macros remain intact even if the IT department decides to update the Normal template.

There are a few things to work out here, before suggesting how this situation might be approached. First, Brett needs to determine where his Normal template is stored. If it is stored on a network drive so that it is being accessed by multiple people on the network, then Brett should probably not be modifying it anyway—it is under the purview of the IT department and Brett shouldn't be storing his own macros in it.

If, however, the Normal template is on Brett's local machine, that is a different story. This means that the IT department is, in some manner, updating the Normal template not only on Brett's machine, but also on all the other machines on the network. From a user's perspective, this is just a little rude. (OK, quite a bit rude, and a bit draconian to boot.) The company should be developing their own set of custom templates and then storing those in a particular location that doesn't involve overwriting any user's Normal template. That approach involves setting the Workgroup Templates location, as described in this tip.

Regardless of what the company should do, they will, of course, continue to do what they want to do—including the overwriting of Brett's Normal template. Brett can take some steps to protect his macros, including periodically exporting the macro modules from the Normal template to a backup location. You can do that by following these general steps:

  1. Press Alt+F11 to display the Visual Basic Editor (VBE).
  2. In the Project Explorer area at the left of the VBE, locate the Normal project.
  3. Expand the Modules folder under the Normal project. (Modules are the organizational element that contain your macros.)
  4. Right-click on the module you want to export. The VBE displays a Context menu.
  5. Choose Export File from the Context menu. The Export File dialog box is displayed.
  6. Use the controls in the dialog box to specify a name for your backup and the location where it should be stored. (You can store it on the desktop for the time being and, later, outside of Word, move it to a more secure location.)
  7. Click the Save button.
  8. Close the Visual Basic Editor.

This is a particularly good approach if your macros don't change all that often—whenever the Normal template is updated, you can simply use the backups to import the macro modules back into it. (You import the macros by following the steps just outlined but choosing Import File from the Context menu displayed in step 4.)

Of course, over time this may turn into a game of whack-a-mole. You have to remember to keep your macro backups up to date, and you'll need to take steps to update your Normal template whenever the IT department does their work. A better solution is to simply create your own "global" template that contains your macros. You can store this template in your startup folder, and then it will be available whenever you start Word. Just move the macros to a brand-new, empty template. (A good way to do this is to export them from the Normal template using the steps already discussed. Delete the modules from the Normal template after exporting, and then use the Visual Basic Editor to import those modules into the new, empty template.)

Next, you'll want to store this new template in the Startup folder. The location of this folder can vary from system to system. To me, the easiest way to discover the Startup folder location is to follow these steps:

  1. Display the Word Options dialog box. (In Word 2007 click the Office button and then click Word Options. In Word 2010 or a later version display the File tab of the ribbon and then click Options.)
  2. Click Advanced at the left of the dialog box.
  3. Scroll to the bottom of the options and click File Locations. Word displays the File Locations dialog box. (See Figure 1.)
  4. Figure 1. The File Locations dialog box.

  5. In the list of File Types, choose Startup.
  6. Click on Modify.

The resulting dialog box indicates the location of the Startup folder being used by Word. Once you have the location of the Startup folder, close Word and use Windows to copy the template into this folder. The next time you start Word, the template is opened automatically and all the macros it contains are available, the same as if they were still in your Normal template. Plus, they won't be disturbed by anything your IT department may do to your Normal template.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13648) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Office 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Hiding Columns Based on a Cell Value

Need to hide a given column based on the value in a particular cell? The easiest way to accomplish the task is to use a ...

Discover More

Modifying What is Started when You Start Windows

Did you know that Windows automatically starts extra programs whenever you boot your system? If you want to see which ...

Discover More

Viewing Comments

Adding comments to a document is a normal activity when writing and editing. Once comments have been added, you may ...

Discover More

Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!

More WordTips (ribbon)

Selecting a Bookmark in a Macro

Bookmarks can be very handy in a document. Word provides a VBA command you can use to easily select any of those bookmarks.

Discover More

Printing Summary Information from a Macro

Part of the information that Word maintains about each of your documents is a summary statement, which you can define in ...

Discover More

Checking for a Text Selection Length

Need to know if the user selected some text before running your macro? Here’s how to make that check.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five minus 0?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.