There is no workbook setting that I know of to stop a save prompt. The only
way I know of to achieve this is by a macro that uses the Before_Close
event. You wouldn't have created such a macro by error.
I did find two articles discussing unusual circumstances where you might not
get a prompt. I have no other ideas.
--
Jim Rech
Excel MVP
message | Excel has stopped prompting to save the save before closing a changed
file? I
| can't find how to reset so that it prompts to save the file?
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.