ExcelBanter - Excel Save Changes Prompt

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Save Changes Prompt (https://www.excelbanter.com/excel-discussion-misc-queries/128343-excel-save-changes-prompt.html)

Billyg

Excel Save Changes Prompt

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.

Gary''s Student

Excel Save Changes Prompt

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.

All times are GMT +1. The time now is 08:31 PM.