Protecting Macros in a Corporate Environment

Written by Allen Wyatt (last updated September 18, 2021)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365


3

Nancy likes macros; she's created macros. However, she would use them more if they didn't disappear whenever the IT guy in her corporation does an upgrade. She wonders about the best way to protect her macros so that never happens again.

This is a common problem faced by Word users in corporate environments. It is not uncommon to come into work one day and find out that your IT department has decided to update your version of Microsoft Office or even replace your entire computer system. The result is that any macros you previously had on the system are gone.

There are a few ways to get around this issue, and none of them involve bribing, threatening, or harming anyone in the IT department. Instead, you either need to take steps to backup the proper files or you need to change a bit how you are recording your macros.

When it comes to backups, you need to figure out where your macros are being stored. For most people, they are stored in the Normal template. If you can locate the Normal.dotm file on your system, then you can get in the habit of copying it to someplace the IT department can't reach, such as a flash drive. That way, if the Normal template gets overwritten on your system, you can copy it from the flash drive back to its rightful place on your system, if need be. You may also find the ideas covered in this tip to be helpful in your efforts to protect the Normal template, along with the info provided in this tip.

As for changing how you record (or store) your macros, remember that you don't need to place them in your Normal template. Instead, you can place them in other templates that wouldn't be overwritten by something your IT department may do. Store the template(s) in the startup folder used by Word and those templates will be loaded automatically whenever you start Word. This means that the macros in those templates will be available during your Word session.

How do you locate the startup folder used by Word? Normally it is at %APPDATA%\Microsoft\Word\STARTUP, but you can find out for sure by following 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 on your machine.

If you would like some good ideas on how to approach putting your macros into templates other than the Normal template, check out the webpage at this link:

https://cybertext.wordpress.com/2009/10/18/word-separate-out-macros-and-attach-them-to-all-documents/

Yes, this is an older page, but the info it contains is still quite relevant to working with the latest versions of Word.

Most of the ideas discussed in this tip are very helpful if you want to protect your macros when your system is subject to periodic updating by the IT folks. If, however, you are concerned about your entire system being replaced, then the best solution is the one discussed near the beginning of this tip—make backups of your Normal template or any other templates in which you may have macros.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11301) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 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

Transposing Two Characters

If you have two characters in the wrong order, you might be interested in a shortcut you can use to switch their order. ...

Discover More

Copying Comments to Cells

Need to copy whatever is in a comment into a cell on your worksheet? If you have lots of comments, manually doing this ...

Discover More

Converting Numbers to Text

Got some numbers you need spelled out? Here's a handy macro that can convert numbers like "123" to words like "one ...

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)

Removing a Directory

Your macro, in the course of doing some processing, may create a directory that you later need to delete. Here's how to ...

Discover More

Renaming a File

Need to rename a disk file from within a macro? You can do it using the Name command, described in this tip.

Discover More

Changing the Default Drive

Macros can be used to read and write all sorts of files. If those files are on a different drive than the current one, ...

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}] (all 7 characters, in the sequence shown) 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 2 + 8?

2021-09-20 12:55:52

Randy

Where documents can end up on many different computers, consider not relying on a customized template that must be attached. I keep my most used macros in what I call a master document (just a .docm) which I copy or “Save As” to create new documents. If you wish, you can set the document properties to “read only” so you don’t accidentally overwrite it. For my less used macros and styles, I maintain another document and use Word’s “Organizer” to import only what I need. I don’t rely on the Normal template for macro or style storage, so replacement of the Normal template is not a problem. Be aware that there may be other customized items stored inside the Normal template that I’m not using.

This may not be ideal for many Word users because it requires the master document(s) containing the macros and styles must be updated with new or corrected macros and styles. My older documents do not update automatically with changes (which I find desirable), but can be updated from the master document using the Word’s Organizer. The macros and styles are separate in each document which is not efficient, but the documents are stable.

This method has worked well for me, and I have shortcuts to access my master document(s). I started using this strategy with older versions of Word/Windows where I received documents that were separated from their original, unique, and unavailable templates sometimes resulting in misleading “Cannot Save. Disk is full” messages [solved by the resetting the document’s template to the my local Normal template--which then sometimes required reformatting the document (applying or copying in and reapplying styles), but then I had no future problems].


2021-09-19 19:32:49

Rob

Regarding the second approach - working in a corporate environment and saving macros in another template(s) in the startup folder used by Word. With this method, you are still vulnerable if the IT department re-images or changes your computer, unless you back up the file to a flash drive - just as described backing up the normal template in the first approach described above.


2021-09-18 04:32:56

KE

It is not a good idea to copy the Normal template and re-instate it after IT have done their thing because IT might have added useful stuff to the Normal template, for example changes to corporate fonts.


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.

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