View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default 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