XL: Error When Macro Closes Its Own Workbook

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel 98 Macintosh Edition
• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, if a Microsoft Visual Basic for Applications procedure is started by an OnSheetDeactivate command and the procedure then closes the workbook in which it is contained, one of the following may occur:

• In Microsoft Excel 97, you receive an illegal operation error.



• In Microsoft Excel for Windows, you receive a general protection (GP) fault.



• In Microsoft Excel for the Macintosh, you receive the following error message:

  The application "Microsoft Excel" has unexpectedly quit, because an error of type 1 occurred.

CAUSE

This behavior occurs only if a sheet is deleted by clicking Delete Sheet on the Edit menu or from the Sheet Tabs shortcut menu; it does not occur if a sheet is deactivated by switching to another sheet.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: 8.00 XL97 crash hang freeze lock-up

Keywords : kbprg kbdta PgmOthr KbVBA
Version : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,97
Platform : MACINTOSH WINDOWS
Issue type : kbbug