E
ezil
Display alerts = false is not working suddenly. Previously when I use in
macros it was working. So I tried following example then also it gives the
alert message
"save changes yes or no?" e.g 2 also gives alert message
Example
This example closes the workbook Book1.xls and doesn’t prompt the user to
save changes. Any changes to Book1.xls aren’t saved.
Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
eg:2 Workbooks("BOOK1.XLS").Close SaveChanges:=False
macros it was working. So I tried following example then also it gives the
alert message
"save changes yes or no?" e.g 2 also gives alert message
Example
This example closes the workbook Book1.xls and doesn’t prompt the user to
save changes. Any changes to Book1.xls aren’t saved.
Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
eg:2 Workbooks("BOOK1.XLS").Close SaveChanges:=False