prompt to save when closing file

G

granty

My excel files no longer prompt me if I want to save changes when closing,
which is frustrating if i have made changes and have forgot to save them. Is
there a quick way to get this prompt back?
 
I

iliace

Are macros enabled, and is there code in the workbook? It is possible
that the Workbook_BeforeClose() method is setting ThisWorkbook.Saved =
True, which would cause Excel to think the changes have been saved and
therefore not display a "do you want to save" prompt.

Press Alt+F11, find the project attached to the workbook you're
working with, and double-click on ThisWorkbook to see the code.
 
G

granty

Thanks for the reply iliace
Unfortunately this seems to be happening for all my workbooks, not just the
ones with macros and code. I had a problem with Excel last week and the IT
department had to re-set my profile - this problem has arisen since then so
probably best if i refer it back to the lovely IT helpdesk! Thanks anyway.
 

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

"Save file before closing" 2
Excel Save Changes Prompt 1
how to disable save prompt on closing excel file in automated mode 3
Shared/Read Only WITHOUT Save prompt 3
Prompt to save when no changes made 1
Turning off prompt to save file with no changes 5
Why does Excel ask to Save on Exit? 6
Do you wish to save prompt 1

Top