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
|