Excel: How auto_close Is Invoked on Each Platform

 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 "Save changes?" 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, "Save changes?" appears before the auto_close macro is invoked.

Microsoft Excel Version 2.10 for Microsoft Windows

This version invokes auto_close after the "Save changes?" 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 "Save changes?" 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 "Microsoft Excel Functions and Macros" version 2.2 manual. For methods of avoiding the "Save changes?" message, query on the following word: 

   SAVE.AS(,0)

KBCategory:
KBSubcategory:

Additional reference words: 2.2 2.20 2.10 2.1

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.