Could somebody please tell me what code i need to write into a macro t
remove the pop up box asking you to update links when opening a file??
I want this to be automated and not for my end user to have to click th
update button.

Thanks in advance, enjoy your weekends, thank goodness it is friday!!

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

--
Hi Paul,

Set the UpddateLinks property of the Open method to True, e,g,:

Workbooks.Open "Book1.xls", UpdateLinks:=True


---
Regards,
Norman



"PaulOakley" wrote
in message ...

Could somebody please tell me what code i need to write into a macro to
remove the pop up box asking you to update links when opening a file???
I want this to be automated and not for my end user to have to click the
update button.

Thanks in advance, enjoy your weekends, thank goodness it is friday!!!


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile:
http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=391227

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