Message still appears with DisplayAlerts = False & SaveChanges:=Fa

  • Thread starter Thread starter wpiet
  • Start date Start date
W

wpiet

In an Excel 2003 macro, I have 3 workbooks, each of which I close with this
code:

ActiveWindow.Close SaveChanges:=False

This has run for months without incident but now, in each instance, pops up
a form entitled "Document modified," with the prompt:
"The active document has been changed. Save Changes?"

So, I added, before the Close method: "Application.DisplayAlerts = False".

The message still appears when it hits the Close.

The macro was originally written in Excel 2003 & all the workbooks invloved
are Excel 97-2003 .xls files.
However, I am now using Excel 2007, though the primary user of the workbooks
& the macro is still using 2003.

I had made some changes to the macro through my Excel 2007. It had the .xls
open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm.
Windows Explorer shows it as file type "Excel 97-2003 Worksheet."

Is there something in the 2003 - 2007 relationship that might cause this
problem?

Thanks,
Will
 
Thanks, Simon. That took care of it.
Any idea why that was popping up, when it never had before in all the months
it's been running?
--
Will


Simon Lloyd said:
If you are not saving changes then you can also add this line:
Click to expand...
VBA Code:
--------------------

Activeworkbook.Saved=TRUE
Click to expand...

--------------------



Excel will think it has already been saved and you should not be
alerted.



In an Excel 2003 macro, I have 3 workbooks, each of which I close with
this
code:

ActiveWindow.Close SaveChanges:=False

This has run for months without incident but now, in each instance,
pops up
a form entitled "Document modified," with the prompt:
"The active document has been changed. Save Changes?"

So, I added, before the Close method: "Application.DisplayAlerts =
False".

The message still appears when it hits the Close.

The macro was originally written in Excel 2003 & all the workbooks
invloved
are Excel 97-2003 .xls files.
However, I am now using Excel 2007, though the primary user of the
workbooks
& the macro is still using 2003.

I had made some changes to the macro through my Excel 2007. It had the
.xls
open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm.
Windows Explorer shows it as file type "Excel 97-2003 Worksheet."

Is there something in the 2003 - 2007 relationship that might cause
this
problem?

Thanks,
Will


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=184739

Excel Live Chat

.
Click to expand...
 
Back
Top