Microsoft KB Archive/108507: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 57: Line 57:
<div class="errormessage">
<div class="errormessage">


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


</div></li></ul>
</div></li></ul>

Latest revision as of 10:35, 20 July 2020

Knowledge Base


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:

  • 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 XL

Keywords: kbbug kbpending kbprogramming KB108507