Error When Macro Closes Its Own Workbook
Article ID: 108507
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q108507
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:
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 XL
Keywords: kbbug kbpending kbprogramming KB108507