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.
 

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

Excel file won't save to iCloud on Mac 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Save workbook without shapes 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Make changes in the outlook file save as type using C# 0
Make "File in use" message appear when 2 people open the a shared document in the same time 3

Top