Microsoft KB Archive/63804

{| = Excel: How auto_close Is Invoked on Each Platform =
 * width="100%"|

Last reviewed: November 30, 1994

Article ID: Q63804

SUMMARY
The time at which the auto_close macro is invoked depends upon the platform that Microsoft Excel is being used on. Following are descriptions of how auto_close is invoked on each platform:

Microsoft Excel Version 2.20 for Apple Macintosh
This version invokes the auto_close macro before displaying the &quot;Save changes?&quot; message when the macro sheet is closed by choosing Close from the File menu or when the close box is clicked on the macro sheet. However, if the macro sheet is closed by choosing Quit from the File menu, &quot;Save changes?&quot; appears before the auto_close macro is invoked.

Microsoft Excel Version 2.10 for Microsoft Windows
This version invokes auto_close after the &quot;Save changes?&quot; message appears. This means that it isn't possible to take complete control of documents with auto_close.

Microsoft Excel Version 2.20 for OS/2
In this version, auto_close behavior is best. The only situation where the &quot;Save changes?&quot; message appears before auto_close is invoked is when Microsoft Excel is exited by closing the application window from the System menu.

MORE INFORMATION
For more information on auto_close, see page 139 of the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual. For methods of avoiding the &quot;Save changes?&quot; message, query on the following word:

SAVE.AS(,0)
 * }