File close excel does not ask me to save changes

Does anyone know how to turn on the alert which comes up to ask you if you
want to save changes, when you do File Close in Excel, but you have unsaved
changes. It currently just closes the workbook and I lose all my changes.
I am working in Excel 2002.

Cathy

Are you running SAP Business One-Outlook Integration?

See the discussion here......

http://snipurl.com/fjyj


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 02:32:02 -0700, Cathy Humphreys <Cathy
[email protected]> wrote:

>Does anyone know how to turn on the alert which comes up to ask you if you
>want to save changes, when you do File Close in Excel, but you have unsaved
>changes. It currently just closes the workbook and I lose all my changes.
>I am working in Excel 2002.

perhaps in one of the macros there is a code statement
application.displayalerts=false
and there is no statement at the end (which it should have had )
application.displayalerts=true.

Now try typing this code
aopplication.displayalerts=true
in the immediate window and keep thecursor at the end of the line and hit
enter
do you get the alerts now.



MVPs may give a better solution.


Cathy Humphreys <Cathy [email protected]> wrote in message
news:[email protected]...
> Does anyone know how to turn on the alert which comes up to ask you if you
> want to save changes, when you do File Close in Excel, but you have
unsaved
> changes. It currently just closes the workbook and I lose all my changes.
> I am working in Excel 2002.