Well, the lines of code to literally do what you ask are as follows:

ActiveWorkbook.UpdateRemoteReferences = False
Application.AskToUpdateLinks = False

However, any Excel file that is opened will open with whatever options
were selected at the time the file was last saved. You cannot change
this, even with an "auto open" macro. Of course, after the file has
been opened, you can have a macro change the options, or you could
change them manually.

I am not sure if this helps. But I have tested this on Excel 97, which
I have on my computer at home.

Let me know if I can help further.

Rafael Ortiz

"Sandy" wrote in message ...
Dear Rafael:

Thanks. I tried it in Workbook Open and it got rid of the
message, but it popped up a different one . . . Select
sheet to link to, with a list of sheets. Do you know how
to get rid of that too?

Sandy

-----Original Message-----
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
.