Updatelinks

J

John Brenner

Hi All -

I need to supress the updatelinks question that appears when you open the
excel file. I am not using workbooks.open - I'm simply double-clicking on the
file. Is there a small piece of code that I can put in the Workbook (Open)
'module' so that the links are automatically updated (Updatelinks = 3)?

Thank you!
 
D

Dave Peterson

Nope.

By the time excel gets to your macro, the links have already been addressed.

You can toggle that setting via the user interface before you open the
workbook--If you need a macro, maybe you could have another workbook that
toggles the setting, then opens the real workbook.
 
Top