What to Do with Macro Code in Microsoft Word
Somebody gave you some code to use, but you don't know what to do with it?
This should help, though you may require more information than they gave you.
These are general instructions and won't likely work for everyone under every
For All Documents
If you want the code to be able to run in any document, then it must be
stored in a global template. Some people will tell you not to use
normal.dot, which is the
default global template. However, I think it's fine to use it, but you should
read about normal.dot,
understand it, and protect a copy of it.
Open Word. Hit Alt+F11 or ToolsàMacroàVisual
Basic Editor (VBE).
If you don't see it as shown in the screen capture above, you may need to
choose from the menu, ViewàProject Explorer, and
On the left, select Normal.
From the menu, choose InsertàModule.
The new module appears and a code window appears at right.
Paste the code you were given in the code window at right.
Hit the Save diskette on the toolbar. This saves normal.dot
regardless of any other settings.
Click here to learn how to assign the macro to a toolbar button or shortcut
For a Single Document
Use the same instructions as provided For All Documents, except
instead of choose Normal from the Project Explorer window, you must open your
document, go to the VBE and choose Project (Your Document). You'll still insert
a module, etc.
Run When the Document Opens or Is Newly Created
Whether you use it for all documents (place the code in Normal)
or only for a specific document (place in the single document), you can run code
when a document opens or when a document is newly created.
Double-click the document. We have chosen Document1. Then, from
the drop-down at the top of the code window, choose Document.
A new Document_New procedure is created for you, but no code is provided.
Document_New will only work if your document is a template. The Document_New
event is fired when a new document is created from a template. Change "New" to
"Open" to have it work when the document is opened.
You may need to take the code provided, remove the first and
last lines, and paste the remaining code between the Private Sub... and End Sub
lines in the code window.
Don't forget to hit the Save diskette.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved