View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ezil ezil is offline
external usenet poster
 
Posts: 43
Default 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