MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DisplayAlerts = False --Not working for one box!


Posted by John Rouse on July 03, 2001 8:03 AM

I have a flawless macro now with help from graet people on the board. All i have now is to disable a pop up box:
The workbook you opened contains automatic links to info. in another workbook. Do you want to update this with changes to the other workbook?

Well. I have to click no. The:
Application.DisplayAlerts = False
Works for all the other pop ups, read only etc... but not this one. Is there a way to get rid of this, or simply press NO? Thank you for your help. This creates minutes of work of putting together hundreds of files together! WOO!


Posted by Ben O. on July 03, 2001 8:18 AM

You can use Application.AsktoUpdateLinks = False, but this has too many drawbacks for me to ever use. For one thing, it turns off the dialog box in the application itself, so it will never ask you to update links in any workbooks. This would be okay, but if it doesn't ask you it goes ahead and update links, since "yes" is the default answer. That's a problem when you've got a worksheet with dozens of links. Finally, you can forget about setting this option to false when you open the workbook and then setting it back to true when you close it, since Excel asks you to update links before it runs a worksheet's Auto_Open macro. I hope this issue is addressed in Excel 2002.

-Ben