Check your macros:

If DisplayAlerts is set to false, then the allert will not be issued
If ThisWorkbook.Saved is set to true, then Excel will think the save has
already happened.
--
Gary's Student
gsnu200703


"Billyg" wrote:

How do I set Excel to prompt me to save changes when closing file? For some
reason, all of a sudden, when I make changes to a file and close it without
manually saving, I don't get asked if I want to save the changes anymore.