XL98: Type 2 Error Message Saving a Workbook or Add-In

ID: Q184367

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98, when you save a workbook, you receive the following error message:

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

   You should save your work in other open applications and restart the
   computer.

CAUSE

This problem occurs under the following circumstances:

You type code in the BeforeSave event for the workbook.
```
    -and-
```
You set the IsAddin property for the workbook to True.

WORKAROUND

To work around this problem, remove the code in the BeforeSave event for the workbook. To do this, follow these steps:

1. On the File menu, click Open to open the workbook (or add-in).

2. Press OPTION+F11 to view the Visual Basic Editor.

3. On the View menu, click Project Explorer.

4. Select the ThisWorkbook object for the workbook, and then click

   Code on the View menu.

5. In the Code window, click Workbook in the Object list and click

   BeforeSave in the Procedure list.

6. Delete the code in the Workbook_BeforeSave event procedure.

7. Save the workbook.

STATUS

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

Additional query words: XL98 ipf gpf addin

Keywords          : kbprg kbdta xlloadsave xlvbainfo xlvbmigrate 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: June 30, 1999