update links (ignore previous post same title)

[Guest]

I have an add-in link to a template. Whenever a file is created on the basis
of this template and the file is opened, user is prompted about updating
links.

To avoid it, I tried

sub Workbook_Open()
..........
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
........

which doesn't work, because the message pops up before _open is run. How do
I do this ???

Thanks

 

[Guest]

Hi,
Is the book being open progmmatically from a Sub or manually from the user?
If from a sub, you might want to try:
Application.AskToUpdateLinks = False
'... open book here
Application.AskToUpdateLinks = True

Regards,
Sebastien

 

[Guest]

Manually by the user

Hi,
Is the book being open progmmatically from a Sub or manually from the user?
If from a sub, you might want to try:
Application.AskToUpdateLinks = False
'... open book here
Application.AskToUpdateLinks = True

Regards,
Sebastien