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

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