the prompt to update links is fired before any code runs.

You can have the links updated without prompt by going into tools=Options
and on the edit tab, uncheck ask to update automatic links.

In xl2002 and later, you have an option to disable the prompt and not update
under Edit=Links.

In versions earlier than xl2002, there is no option to not update automatic
links and not prompt. You would need to open a 2nd workbook which uses code
to open the workbook with links using

Workbooks.Open "NameofWorkbookwithLinks.xls", updateLinks:=0

--
regards,
Tom Ogilvy

"julio" wrote in message
...
I have an add-in linked to a template, based on which a file is created.
When
the user opens this file, he 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 get this to work ???

Thanks