Excel Save Changes Prompt

B

Billyg

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.
 
G

Gary''s Student

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.
 
Top