update links (ignore previous post same title)
 

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

update links (ignore previous post same title)
 

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

"julio" wrote:

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

update links (ignore previous post same title)
 

Manually by the user

"sebastienm" wrote:

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

"julio" wrote:

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