J
JMPS
I was wondering if there was an easy way to exit Excel automatically once all the Aut
pen Macros completed.
pen Macros completed.
L
libby
hi
Try Application.Quit to exit the whole of excel or
ThisWorkbook.Close to close the current workbook.
pen Macros completed.
Try Application.Quit to exit the whole of excel or
ThisWorkbook.Close to close the current workbook.
automatically once all the Aut
pen Macros completed.
J
John Wilson
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
pen Macros completed.
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
all the AutJMPS said:
pen Macros completed.