Hi

I am having trouble with turning off the promt for
updating links.

I have tried the following commands but I still get a
message re updating links.

I think they automatically update the links but I want the
program to not Update links.

Application.AskToUpdateLinks = False
ActiveWorkbook.UpdateLinks = False

TIA

In versions of Excel prior to xl2002, you either update automatic links
without prompt, or you get prompted. The only way around this is to open
the workbook with code since the open method has an argument UpdateLinks
which can be set to not update links. In xl2002 and later, there is an
option in the Links menu under the edit menu.

--
Regards,
Tom Ogilvy

"Edgar Thoemmes" wrote in message
...
Hi

I am having trouble with turning off the promt for
updating links.

I have tried the following commands but I still get a
message re updating links.

I think they automatically update the links but I want the
program to not Update links.

Application.AskToUpdateLinks = False
ActiveWorkbook.UpdateLinks = False

TIA