Excel Save Changes Prompt

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shared/Read Only WITHOUT Save prompt 3
prompt to save when closing file 2
Changes not saved 3
Why does Excel ask to Save on Exit? 6
Excel prompts to save when no changes made 2
Turning off prompt to save file with no changes 5
Save Changes Prompt at close 2
No "save changes" when exiting Excel 2003 3

Top