Updatelinks
 

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

Updatelinks
 

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