Excel - Automatic links

[MikiH]

Hi

I've created a macro that opens workbooks, these workbooks have links to other workbooks. What code do I use to set the lookup value to yes and prevent excel from asking me the question 'Do you want to update links'



Thanks
Mick