| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing sheets and selecting 'no' automatically
Graham Whitehead wrote: 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. have look he http://www.vbcity.com/forums/topic.asp?tid=29144 this is way to close without saving |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set macro to run automatically when closing workbook? | Excel Discussion (Misc queries) | |||
| automatically close form before closing | Excel Discussion (Misc queries) | |||
| Automatically closing workbook | Excel Programming | |||
| closing userform automatically | Excel Programming | |||
| Closing Dataform automatically | Excel Programming | |||
Hybrid Mode
