Disappearing Macro Menus

by Allen Wyatt
(last updated September 1, 2014)

1

Martyn has a large collection of macros that he has built up over the course of several years. Each of these macros has been added to two lengthy custom menus. Recently, if Martyn edits any of the macros and then saves the template, the next time he starts Word all the entries in the custom menus are gone. The only remedy seems to be to restore the most recent backup of Normal.dot and, as a consequence, lose his editing.

There could be any number of reasons why this problem is occurring. The most likely problem is some sort of corruption in the Normal.dot file. Other issues of WordTips address how to handle corruption in the Normal.dot file, but none of those remedies will seem very satisfying in this situation because of the large number of macros that could be lost by salvaging the Normal.dot template.

The best solution is to move the macros out of the Normal.dot template and into a different template. That way, any corruption in Normal.dot will not affect your macros because they are no longer in that template.

For instance, let's say you move the macros to a template called MyMacros.dot. You could then move the template file to Word's Startup folder, where it will be recognized and loaded as a global template the next time you start Word. This means that all the macros within the template are now available at all times, just as they were when they were in the Normal.dot template.

Of course, when you move your macros to a new template (normally using the Organizer or moving them within the VBA Editor itself), this can "break" the menus you created. The reason for this is that the menus--and any custom toolbar buttons--point to the ProjectName.ModuleName.MacroName. When you move the macro to a different template, you are changing the ProjectName and possibly the ModuleName and MacroName.

Your options at this point are to recreate the menus, but if you have dozens (or scores) of macros added to the menus, this can be a real pain. You could, instead, try these general steps, prior to moving the macros, if you are using a version of Word prior to Word 2007:

  1. Choose Tools | Customize to display the Customize dialog box.
  2. On the Toolbars tab, click New. Word displays the New Toolbar dialog box. (See Figure 1.)
  3. Figure 1. The New Toolbar dialog box.

  4. Enter the name "Backup1" as the name of your new toolbar, then click OK.
  5. Display the Commands tab of the Customize dialog box. (See Figure 2.)
  6. Figure 2. The Commands tab of the Customize dialog box.

  7. At the very bottom of the Categories drop-down list, you will find "New Menu." Drag this option to the newly created Backup1 toolbar.
  8. Name this menu as Backup, plus the same name as your first existing custom menu. So if your first custom menu is Custom1, call this menu BackupCustom1. (This is not absolutely necessary, but will make the new menu easier to later find.)
  9. Repeat steps 1-6, but this time substitute Backup2 for Backup1 and name this menu BackupCustom2.
  10. With the Customize dialog box still open, click on your original Custom1 menu, hold down the Ctrl key, and drag each item from your Custom1 menu to your BackupCustom1 menu, one at a time. By holding down the Ctrl key, you will be copying these items, rather than moving them.
  11. Do the same with the Custom2 menu, copying each item to the BackupCustom2 menu.

Unlike your original menus, these newly created menus (on the new toolbar) can be copied and saved to a brand new template. Use the Organizer to copy the new toolbars and your macro modules to a new template. This template can be placed in the Word Startup folder, as described earlier.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (431) applies to Microsoft Word 97, 2000, 2002, and 2003.

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

Stepping Through Head Formats

You can use the shortcuts described in this tip to quickly change the heading levels of the headings in your document. You'll ...

Discover More

Changing Table Cell Text Direction

When creating a table, you can turn the orientation of the text, within a cell, by ninety degrees in either direction from ...

Discover More

Heading Changes for Multi-page Tables

When you have a long table that extends over multiple pages, Word allows you to specify one or more rows to be repeated at ...

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 (menu)

The Case of the Vanished Menu Bar

Can't find your menu bar any more? Here are some things you can try to get that important feature back on your screen where ...

Discover More

Making Macros Readily Available

Want to get at your macros quickly? One way is to create a Macros menu to make your most common macros immediately available.

Discover More

Keeping Full Menus Displayed

Word allows menus to be displayed in two modes. The default mode, which displays menu options dynamically, drives some people ...

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 7 + 6?

2012-11-22 07:12:43

Jedumi

Hi Allen,

I've searched everywhere for info on the following - with little or no success. I am a 'power' user, so I understand things well - especially when it comes to Word. However, I am failing to get a custom item (saved in a custom template in Startup) to appear on Word's standard Menu Bar when I start Word - even in a test environment, with only a test template in Startup (to avoid any conflicts). (I can, of course, create custom Toolbars and save them in the custom template, but I'm talking about adding a custom Menu Bar item that is NOT saved in Normal.dot.) What am I missing?


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon 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.