Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exiting a workbook
David,
Application.DisplayAlerts = True should do it. Another way would be to fool the workbook into thinking it's already saved. ThisWorkbook.Saved = True just before the "close" should work. John David Ralph wrote: 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 Excel | Excel Discussion (Misc queries) |