Yes, it will ask. It is based on their setting. This question is asked
long before any code runs, so you can't put code in your workbook that will
supress this prompt.

You can only do this by having the user open a dummy workbook with no links
and have that workbook open the real workbook with code.

--
Regards,
Tom Ogilvy


Sandy wrote in message
...
Hi Tom!

Thanks for your reply. The reason I was asking for code
to do this is because I am assuming that if the person
receiving the email has "ask to update automatic links"
checked, it will ask them regardless of the fact that my
options are unchecked. Is this a correct assumption? By
the way, this is Excel 97 I am talking about.

Do you know what the code is if my assumption is correct?

Sandy

-----Original Message-----
tools=Options=Edit, uncheck
ask to update automatic links.

then the links are updated without prompt. If you don't
want them updated,
then there is no option for this except in xl2002.

In Excel 2002, there is an option under the Edit=Links
menu to not prompt
and not update.

--
Regards,
Tom Ogilvy



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


.