Do you wish to save prompt

[Guest]

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!

 

[Guest]

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