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" <(E-Mail Removed)> wrote in message
> news:64A3D357-48B1-47EE-B815-(E-Mail Removed)...
> > 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
>
>
>
|
Similar Threads
