bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Macros > Managing Macros > Macro Error when Closing Document

Macro Error when Closing Document

Summary: Word can run macros both when opening and closing a document, if such macros exist. If there is an error in the macro, you’ll see an error message. How you get rid of the error message is described in this tip. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

Patricia Malyon is experiencing a situation where she is getting errors whenever she closes a document. Specifically, the error says "Compile Error in Hidden Module: Main." This error is caused by a macro that is somehow failing to run, as Word expects it to, every time a document closes.

If this error occurs with every document being closed, there is a good chance that the offending macro is in the Normal.dot template. Another clue is that the "Main" reference indicates that the macro is probably from an older, pre-Word 97 version of Word. (Prior to Word 97 the macro language used was WordBasic, and it used Main as the name of the primary entry point for a macro.) If you've upgraded recently to a newer version of Word, then the macro that used to work fine under your older version of Word may now have problems in the newer version.

The only way to fix such a problem is to examine the add-ins and macros associated with your documents and templates. Tracking down the problem can be frustrating, particularly if you are unfamiliar with macros and the VBA Editor, but it is the only way to really fix the problem. Chances are good that the offending macro is part of (or referenced in) a FileClose or AutoClose macro.

One good online source of information for problems such as this is at the Word MVP site. Take a look at the following Web page, particularly section four. It includes information and guidance that may be helpful:

http://word.mvps.org/FAQs/AppErrors/ProbsOpeningWord.htm

Tip #188 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003


Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books.
 
Check out WordTips Premium today!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home

WordTips FAQ
WordTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)