display alerts= false not working
It is true that my experience is different. However I solved the problem.
This message may be useful for someone who may encounter same problem like
me. What I did is, I removed internet explorer from my system and again I
reinstalled. Then the problem became o.k. IE seem to be corrupted.
"Norman Jones" wrote:
Hi Ezil.
Workbooks("BOOK1.XLS").Close _
SaveChanges:=True
Should save any chnages and close the workbook
without any message
Similarly
Workbooks("BOOK1.XLS").Close _
SaveChanges:=False
should close the workbook without saving any changes
and without any alert message.
Alternatively,
Application.DisplayAlerts = False
Workbooks("Book2").Close
Application.DisplayAlerts = True
would also close the workbook without saving any c
hanges and without any warning.
Are you saying that your experience is different?
---
Regards,
Norman
"ezil" wrote in message
...
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
|