Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing files without save
I am writing a macro which opens and closes a series of other workbooks.
When I close a workbook, Excel prompts me if I want to save the file and if I want to delete whatever is left on the clipboard. How can I, in VBA, close a workbook without saving it and not have Excel displaying a dialog box asking if I want to save? Also, how can I surpress the question about the clipboard, and automatically have Excel to discard those items left on the clipboard? Thanks in advance, Warren |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing but doesn't ask to save | Excel Discussion (Misc queries) | |||
Closing files and saving files | Excel Worksheet Functions | |||
Save files before closing | Excel Discussion (Misc queries) | |||
Closing the save changes box | Excel Programming | |||
Closing the save changes box | Excel Programming |