![]() |
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. |
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 wrote in message ... 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 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. |
All times are GMT +1. The time now is 09:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com