Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot Update Links Message is False but Always Appears | Excel Discussion (Misc queries) | |||
VBA - Do Loop or SaveChanges = false | Excel Discussion (Misc queries) | |||
Problem with Activeworkbook.Close SaveChanges:=False | Excel Programming | |||
Where to put DisplayAlerts = False | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming |