This is some code I used in a macro :
Application.DisplayAlerts = False
ActiveWindow.Close SaveChanges:=False
Application.DisplayAlerts = True
On some PC it is closing the file without prompting a dialog to save or not save the file. However on another PC it still prompt for this info ???
Same Excel 2000 SP3 is used on all 4 PC
Does anyone has a clue ??
Application.DisplayAlerts = False
ActiveWindow.Close SaveChanges:=False
Application.DisplayAlerts = True
On some PC it is closing the file without prompting a dialog to save or not save the file. However on another PC it still prompt for this info ???
Same Excel 2000 SP3 is used on all 4 PC
Does anyone has a clue ??