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.

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?

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?