prompt to save when closing file

  • Thread starter Thread starter granty
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top