Thread: Display Alerts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Display Alerts

Maybe you could be more explicit when you close the workbook:

workbooks("book2.xls").close savechanges:=false 'true???

I don't think you'll have to worry about alerts if you tell excel what to do
with your changes.



Valerie wrote:

Sorry it wasn't clear.
Using Application.DisplayAlerts = False
Getting an Alert
Thanks
Valerie
"John Wilson" wrote in message
...
Valerie,

Are you using:
Application.DisplayAlerts = False
???
What do you mean by "not working"??
Are you getting an alert or an error??

John

Valerie wrote:

I have just upgrade to Excel 2000 from 98. Am having trouble with some

old
macros. It seems that DisplayAlerts = False is not working when I try

to
close workbook without saving. Is there something different I need to

do in
2000 version?
Thanks
Valerie



--

Dave Peterson