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. We are researching this problem and will post more information here in the Microsoft Knowledge Base as it becomes available.