V
VBA_Newbie
I am wondering if it is possible to write an macro that answers "no
when a spesific alert is shown in Excel 2003. The alert is the aler
where excel asks you if you want to save the excel document becaus
"excel recalculates formulas when opening files last saved by a
earlier version of Excel".
I like to keep track of the dates when documents ar stored, and I a
therefor not interested in saving them just because excel 2003 wants m
to. The file structure are the same in excel 2003 and Excel XP(which wa
my earlier version)
I am also not interested in turning all alerts off with the vba
Application.DisplayAlerts = False because some alerts are ok to see.
Is there a solution for this?? Please help :
when a spesific alert is shown in Excel 2003. The alert is the aler
where excel asks you if you want to save the excel document becaus
"excel recalculates formulas when opening files last saved by a
earlier version of Excel".
I like to keep track of the dates when documents ar stored, and I a
therefor not interested in saving them just because excel 2003 wants m
to. The file structure are the same in excel 2003 and Excel XP(which wa
my earlier version)
I am also not interested in turning all alerts off with the vba
Application.DisplayAlerts = False because some alerts are ok to see.
Is there a solution for this?? Please help :