G Guest Dec 10, 2003 #1 I was wondering if there was an easy way to exit Excel automatically once all the Auto_Open Macros completed.
I was wondering if there was an easy way to exit Excel automatically once all the Auto_Open Macros completed.
L libby Dec 10, 2003 #2 hi Try Application.Quit to exit the whole of excel or ThisWorkbook.Close to close the current workbook. -----Original Message----- I was wondering if there was an easy way to exit Excel Click to expand... automatically once all the Auto_Open Macros completed.
hi Try Application.Quit to exit the whole of excel or ThisWorkbook.Close to close the current workbook. -----Original Message----- I was wondering if there was an easy way to exit Excel Click to expand... automatically once all the Auto_Open Macros completed.
J John Wilson Dec 10, 2003 #3 JPMS, In addition to the other responses that you rec'd, you might want to use: Application.DisplayAlerts = False just before the Application.Quit This will suppress any prompts to save the workbook if your macros have made any changes to it. John JMPS said: I was wondering if there was an easy way to exit Excel automatically once Click to expand... all the Auto_Open Macros completed.
JPMS, In addition to the other responses that you rec'd, you might want to use: Application.DisplayAlerts = False just before the Application.Quit This will suppress any prompts to save the workbook if your macros have made any changes to it. John JMPS said: I was wondering if there was an easy way to exit Excel automatically once Click to expand... all the Auto_Open Macros completed.
