Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exiting a workbook
Dave
In addition to John's response, there is also a SaveChanges argument to the Close method of the Workbook object that will avoid the prompt. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "David Ralph" wrote in message ... Hi, I'm trying to get Excel to exit without prompting the user to save the workbook. I have aready constructed the IF statement using a MSGBOX, but when you choose the NO option the Excel then prompts you if you wish to save the workbook before exiting. Is there some way of turning off Excels messaging, so it just exits? Cheers Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exiting excel ONLY the workbook will close | Excel Discussion (Misc queries) | |||
How to ensure workbook is saved before exiting Excel? | Excel Discussion (Misc queries) | |||
Message Box on exiting workbook | Excel Discussion (Misc queries) | |||
Re-establish function on exiting workbook | Excel Worksheet Functions | |||
Exiting a workbook | Excel Programming |