Closing sheets and selecting 'no' automatically
Hi, I have some code which collects data from various different workbooks on
a network then applied some formating and prints them. When the stuff has
been printed I just simply want to close the workbook without saving the
changes. Now even if i set Application.DisplayAlerts to false while this
part runs can I be sure that the default is not to save them, i.e. the focus
is not on the yes button. Does anyone know anything about this. Thanks for
your time.
|