Passwords for Creating Macros

by Allen Wyatt
(last updated January 14, 2014)

Subscriber Fran Nault wrote about a problem she was having with Word 2000. It seems that ever since she installed the program, she hasn't been able to create macros. When she trys, she gets a message to enter her password.

This behavior could be caused by several different things, and to correct it you will need to figure out exactly why you are being asked for a password. One place to look as at the template in which you are trying to store the macro. If the template is protected in some way, then you may be asked for a password before the template can be written to. For instance, if the template file is write protected, or if it is stored on a network drive that doesn't allow others to write to it, then the password request you are seeing may be from the operating system itself, not from Word.

It is also possible that if you are trying to save the macro to your Normal.dot file, the file could be corrupted in some manner. You should get out of Word, rename the existing Normal.dot file, and then restart the program. If you are then able to create and save macros, then you know it was a problem with Normal.dot. Someone could also have password-protected the macro module in your Normal.dot file. This is done by displaying the project in VBA Editor, and then choosing Tools | Normal Properties and clicking on the Protection tab. Of course, renaming Normal.dot will help overcome this problem, as well.

Finally, it is possible that you have contracted a macro virus. Check Tools | Macro | Macros (or just press Alt+F8) to see if there are any macros installed on your system that you do not recognize. In most cases, you can eliminate this problem by renaming your Normal.dot file, as described earlier, and making sure there are no files in your Word startup folder.

Another good idea is to make sure that you have the latest Office service packs installed. These help to correct any esoteric problems that may exist, and they help to strengthen security in case you have contracted a macro virus.

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

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

Errors when Copying References to External Cells

If you copy a cell that contains a reference to external data, do you get an error? It could be due to the complexity of the ...

Discover More

Searching and Replacing Graphics

Got a bunch of graphics in a document that need replacing? (Perhaps you need to replace an old logo with a new one.) Word ...

Discover More

Missing PivotTable Data

Wonder what happened to the data behind a PivotTable? It could be in a number of places, and tracking it down could be a ...

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

Converting Text to Uppercase in a Macro

Macros are often used to process documents. If part of the processing involves making text selections uppercase, Word ...

Discover More

Swapping Two Strings

Part of developing macros is learning how to use and manipulate variables. This tip examines a technique you can use to ...

Discover More

Aligning a Paragraph in a Macro

If you are applying formatting from within a macro, you may want to change the alignment of various paragraphs. Here?s how ...

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 for this tip:

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