prompt to save when closing file
 

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?

prompt to save when closing file
 

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.

On Dec 10, 1:03 pm, granty wrote:
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?

prompt to save when closing file
 

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.


"iliace" wrote:

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.

On Dec 10, 1:03 pm, granty wrote:
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?