Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding on a previous post | Excel Discussion (Misc queries) | |||
Validation_List_Formula (not sure how to title this post) | Excel Worksheet Functions | |||
Finding My previous post | Excel Discussion (Misc queries) | |||
Ref:Previous post | Excel Programming |