Turn off Excel's 'want to update info?' prompts

[Alex Hatzisavas]

Thanks a lot for the hint Tom, didn't know this

The idea would be, however, that the 'Ask to update links' optio
should be turned off automatically regardless of the machine on whic
the Workbooks are being opened (the end user may be using anothe
machine).

That is, i would rather deactivate this option with VBA cod
'exploiting' some event that comes before Excel asks the question abou
the updating.

I tried the Workbook_Open() private sub (for the 'Workbook open' event
and the code:

Application.AskToUpdateLinks = False

The problem with this one is that Excel first asks to update th
links, and THEN the 'Workbook open' event is fired, and the private su
above is executed and deactivates the 'Ask to update links' option.

Is there any way i can deactivate this option before Excel asks th
user to update?

Thank you very much for your help

Ale

 

[Tom Ogilvy]

No. No code is run before links are updated.