File close excel does not ask me to save changes

G

Guest

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.
 
R

R.VENKATARAMAN

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.
 
G

Gord Dibben

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
 

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

Why does Excel ask to save when no changes were made? 4
Why does Excel ask to Save on Exit? 6
Excel prompts to save when no changes made 2
Excel 2003: File->Close without saving changes (save menu does no. 5
Not asking to save 2
Save Changes Prompt at close 2
HOW DO YOU GET EXCEL TO ASK IF YOU WANT TO SAVE A FILE ON EXITING 3
xls:1 but no xls:2 1

Top