Don't update Links

[Robin Clay]

Greetings !


I have this:

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False


....and yet, when I open the file, I STILL get asked
whether I want to "Continue" or to "Edit Links"

How can I prevent this box from popping up?


RClay AT haswell DOT com

 

[Tom Ogilvy]

the prompt is run before any macro. So you would have to set this before
opening the workbook. If you do set it to false, it updates the link, it
just doesn't ask.

If you are using xl2002 or later, there is an uption under Edit=>Links that
allows you to control this.

In earlier versions, if you don't want to be prompted and don't want to
update the links, you need open a helper workbook that uses code to open the
actual workbook. You can then use the updatelinks argument to suppress the
link update

workbooks.Open filename:=Actualworkbook.xls, updatelinks:=0