Click on Tools, Options and select the Edit tab
Simply uncheck the "Ask to update automatic links" box

If you want to do it in code then it's
Application.AskToUpdateLinks = False

"walt" wrote in message
...
If I open a specific workbook i get the following
message:

"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?"

I ALWAYS answer that with "no". The open-routine is
done by a macro and
would like answer this question by default with "no".
how?

Application.DisplayAlerts = False does NOT work!
Don't ask me why... :(

Walt





.