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