Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Printing a Macro List.

Printing a Macro List

by Allen Wyatt
(last updated March 29, 2014)

1

Many Word users rely upon macros to perform all sorts of tasks in the program. Over the years it is possible to accumulate quite a few different macros. At some point you may want a way to print out a list of your macros for reference purposes. Unfortunately, Word doesn't provide a way you easily print out such a macro list.

If you just need a quick list, one way to do it is to use Word's built-in tools to list all the commands available to Word. Since Word considers macros to be "commands," the command list will also include your macros. But since you don't want all of the other commands in Word (besides your macros), you will need to do a little editing. Follow these steps:

  1. Press Alt+F8. Word displays the Macros dialog box.
  2. Using the Macros In drop-down list, choose Word Commands. (See Figure 1.)
  3. Figure 1. The Macros dialog box.

  4. In the list of Word commands, select the ListCommands option.
  5. Click on Run. Word begins to run the macro and displays a dialog box.
  6. Click the All Word Commands radio button.
  7. Click OK.

Word then creates a new document that contains a table with all Word commands. Remember that your macros are buried within the table. To find them, search for "normal." (make sure you include the period, but not the quote marks). This finds any "commands" contained in the Normal document template. You can copy the names of these commands—they are your macros—to a different document. If you have macros in any other templates, search for those template names, as well.

Another approach is to follow these general steps:

  1. If your macros are not in the Normal template, open the template that contains your macros.
  2. Press Alt+F11. Word displays the Visual Basic editor.
  3. Double click a module on the left side, so that the code appears on the right.
  4. Select all the code and press Ctrl+C. This copies the macro code to the Clipboard.
  5. Open a new Word document and paste all the macro code into the document.
  6. Press Ctrl+End to move to the end of the document.
  7. Press Ctrl+H. Word displays the Replace tab of the Find and Replace dialog box.
  8. Click the More button if it is available. (See Figure 2.)
  9. Figure 2. The Replace tab of the Find and Replace dialog box.

  10. Make sure the Use Wildcards check box is selected.
  11. Using the Search drop-down list, choose Up.
  12. In the Find What box, type the following: (Sub*\(\))(*)
  13. In the Replace box, type the following: \1^p
  14. Click Replace All.

What you instructed Word to do was to delete everything except the subroutine names (these are your macro names). What is not included in this process are any functions you may have created in your macros. Those functions are not publicly available macros, so for most people this isn't a big issue.

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 (13041) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Printing a Macro List.

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

Searching for Comment Marks

Got a bunch of comments in your document? You can easily jump from one comment to the other by using the Object Browser, ...

Discover More

Workbook, Once Created, is Too Big for Memory

Understanding how Excel uses memory, how much it allows, and how to work around the limitations.

Discover More

Selecting Columns in VBA when Cells are Merged

If you have a macro that selects different columns in a worksheet while processing information, you may get some ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Determining an ANSI Value

You may need to determine the numeric value of a character in a macro. You can do that using the Asc function, described ...

Discover More

Understanding Document Variables

When working with macros, you may want to create a variable that will remain constant from one instance of the macro to ...

Discover More

Repaginating Your Document in a Macro

When processing a document with a macro, you may need to have the macro repaginate the text. It's easy to do using the ...

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

2017-03-14 11:57:06

Pam

In Word 2007, is there a way to view a list of the macros I created along with the keyboard shortcuts I assigned to them? (So not just the names of macros, but also the keyboard shortcut use to activate it). I know how to do it for the macros that "came" with Word, but mine aren't in that list. I could just go through all the combinations of keys to see what they do, but viewing a list would be much easier, obviously, and I would think there would be a way to do this. They're apparently stored in "All Documents (Normal.dotm)." Thanks!


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.