Not from the workbook being opened. the update is attempted or the question
is asked before any code is run.

In xl2003 and maybe xl2002, there is an option under Edit=Links that
concerns this and which I believe is workbook specific. I don't have one of
those versions handy, so I can't give you the exact button name, but it is
in the lower left of that dialog I believe.

--
Regards,
Tom Ogilvy

"funkymonkUK"
wrote in message
...

is there some vb code that can change this option and turn it back on
again?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=523443