Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing but doesn't ask to save
We have someone at our office who must have used an option to turn off the
window that asked you if you wanted to save before exiting. She would like this to ask her again because she will close by accident without saving and then everything is gone. I cannot find this option to turn it back on and I don't know what words to use to describe it in a search engine. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing but doesn't ask to save
I don't know of any such option in Excel. When code is being written in a
macro, it is common to want to disable then re-enable the alerts for some reason. One thing that does happen occasionally in the development phase (of the code) is the "DisplayAlerts = False " code runs, then an error is encountered for some reason, and the DisplayAlerts = True doesn't run. When this happens, you have to take measures to set the DisplayAlerts back to True. This may be your problem. If you think this is a possibility, run this macro: Sub DisplayAlerts() Application.DisplayAlerts = True End Sub No harm will be done if you run this code and this is not your problem. HTH Otto "TJAC" wrote in message ... We have someone at our office who must have used an option to turn off the window that asked you if you wanted to save before exiting. She would like this to ask her again because she will close by accident without saving and then everything is gone. I cannot find this option to turn it back on and I don't know what words to use to describe it in a search engine. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save files before closing | Excel Discussion (Misc queries) | |||
Stop the prompt to save when closing workbooks | Excel Discussion (Misc queries) | |||
Auto Save on closing | Excel Discussion (Misc queries) | |||
how to disable save prompt on closing excel file in automated mode | Excel Discussion (Misc queries) | |||
Save? prompt when closing Excel | Excel Discussion (Misc queries) |