ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display Alerts (https://www.excelbanter.com/excel-programming/276361-display-alerts.html)

Valerie[_2_]

Display Alerts
 
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[_3_]

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



All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com