I have a workbook called "Control" that opens and alters several other existing excel documents. When each of the documents opens, a popup window "This workbook cotains links to other data sources" opens, and I have to select either "update," don't update", or "help." Is there a way to prevent this popup from appearing? application.displayalerts = false doen't seem to work. Thank you!
Try this:
[VBA]Application.AskToUpdateLinks = True
[/VBA]
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
You'll probably want to set it to false.
I looked up update links in VBA help
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
