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

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

--
Alex Hatzisava
-----------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26812

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

No. No code is run before links are updated.

--
Regards,
Tom Ogilvy


"Alex Hatzisavas" wrote in
message ...

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

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

That is, i would rather deactivate this option with VBA code
'exploiting' some event that comes before Excel asks the question about
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 the
links, and THEN the 'Workbook open' event is fired, and the private sub
above is executed and deactivates the 'Ask to update links' option.

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

Thank you very much for your help :)

Alex


--
Alex Hatzisavas
------------------------------------------------------------------------
Alex Hatzisavas's Profile:
http://www.excelforum.com/member.php...o&userid=14559
View this thread: http://www.excelforum.com/showthread...hreadid=268123