Article ID: 177393
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q177393
SYMPTOMS
When you save a Microsoft Excel workbook in Microsoft Visual Basic Editor, you may receive the following error message.
In Microsoft Windows 95
If you click Details, you receive an error message similar to the following:
In Microsoft Windows NT
NOTE: If another workbook is open, it is saved instead of the workbook that you specified. You will receive no error message.
CAUSE
This problem may occur when using the BeforeSave event if either of the following conditions is true:
- The IsAddin property of the workbook object returned by ThisWorkbook is set to True. -or-
- The workbook is hidden.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
REFERENCES
For more information about using the BeforeSave event, click the Office Assistant in the Visual Basic Editor, type beforesave, click Search, and then click to view BeforeSave Event.
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words: XL97 ipf
Keywords: kberrmsg kbbug kbprogramming kbpending KB177393