Good morning PaulOakley

You can turn off the box from within Excels options (Tools Options
Edit, Ask to update automatic links). Unfortunately this is an Exce
setting rather than a workbook setting, so is not saved with you
workbook. To access this setting via VBA you would use the command:

Application.AskToUpdateLinks = False

But then you would get the dialog box asking if you want to run macros
so to get a dialog free file opening you really need to change th
setting in the Options.

Have a nice weekend!

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39122