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!
--
Regards,
John

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.

John Brenner wrote:

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!
--
Regards,
John

--

Dave Peterson