Automatic links message

Posted by John on November 14, 2001 10:48 AM

Can code be written to suppress the following message upon the opening of a file:

"The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"

When I email this file to other users I don't want them to be scared of the messages (there are several linked files). Instead of telling the user to click "no" I would rather have the message not appear at all.

Thank you in advance!

Posted by Juan Pablo on November 14, 2001 1:34 PM

I think that .Open method has a parameter (UpdateLinks) that if set to:

0 Doesn't update links
1 Update external but not remote links
2 Update remote not external
3 Update both

Try with that,

Also, give Application.DisplayAlerts = False a shot.

Juan Pablo

Posted by John on November 15, 2001 5:56 AM

Juan Pable,

I tried "Application.DisplayAlerts = False" and that did not work. I don't understand what you mean with your first solution.