Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do you wish to save prompt
I am no longer prompted to save when I am closing out of excel - even though
I have made changes to the file. Auto-save is still set, however, if I exit before saving excel will just close. I have search through tools/options, but am seeing nothing. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do you wish to save prompt
Look for any macro that has:
ActiveWorkbook.Saved = True in it. Excel wil not prompt you if it THINKS the file has already been saved. For example, puttting the following in ThisWorkbook code will avoid the prompt entirely during File Quit Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.Saved = True End Sub -- Gary''s Student "Kelley" wrote: I am no longer prompted to save when I am closing out of excel - even though I have made changes to the file. Auto-save is still set, however, if I exit before saving excel will just close. I have search through tools/options, but am seeing nothing. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
Save prompt | Excel Discussion (Misc queries) | |||
Save prompt for Excel 2003 | Setting up and Configuration of Excel |