Hi Tom:

Yes, but what about the new message it pops up with . . .
Select sheet to link to, with a list of sheets. Do you
know how to get rid of that?

Sandy

-----Original Message-----
That will certainly change the setting after the question
has been asked.

Regards,
Tom Ogilvy


Rafael Ortiz wrote in message
. com...
Like this:

Application.AskToUpdateLinks = False

MRO

"Sandy" wrote in message
.. .
Hello!

I don't want the dialog box that says "The workook you
opened contains automatic links . . ." "To update all
linked information, click Yes . . ." to display to the
user. How do I disable it in code?

Your help will be immensely appreciated!

Sandy


.