Microsoft KB Archive/120042

{|
 * width="100%"|

XL5: GP Fault Closing Workbook while Macro is Recording

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SYMPTOMS
In Microsoft Excel, you receive a general protection (GP) fault if you use the Close method in a Visual Basic procedure to close a workbook that contains a recording macro.

CAUSE
This problem occurs whether the recording macro is a Visual Basic macro, or a MS Excel 4.0 macro. The GP fault occurs whether you use the saveChanges argument with the Close method, or not. The problem also occurs whether or not you choose to save the changes to the workbook that contains the recording macro.

This problem does not occur if the procedure that closes the workbook and the recording macro are contained in the same workbook.

WORKAROUNDS
To avoid receiving a GP fault when you close a workbook that contains a recording macro, do either of the following:


 * Close the workbook without using a macro by choosing Close from the File menu.
 * Stop the macro recorder before you run the macro that closes the workbook.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel.

MORE INFORMATION
For additional information, please see the following article(s) in the Microsoft Knowledge Base:

"Q108507 XL5: Error When Macro Closes Its Own Workbook" Additional query words: gpf

Keywords :

Version : 5.00

Platform : WINDOWS

Issue type :

Technology :