XL7: Closing Shared Files Using a Macro May Cause Infinite Loop
PSS ID Number: 135510
Article Last Modified on 7/12/2001
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q135510
SYMPTOMS
When you close a workbook using a Visual Basic, Applications Edition, sub
procedure, you may receive a "Save Changes" alert. If you click Yes to save
the changes, the alert will be redisplayed in an endless loop.
WORKAROUND
To work around this problem, click Save As on the File menu, and save the
workbook with a different filename.
STATUS
Microsoft has confirmed this to be a problem in Microsoft products listed
at the beginning of this article. We are researching this problem and will
post new information here in the Microsoft Knowledge Base as it becomes
available.
Additional query words: loop error message macro subprocedure code
Keywords: kbProgramming KB135510
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch