Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links automatically when opening file
This one's got me stumped. I'd like to be able to bypass the update
links dialog box when opening a file. I know I can do this by unclicking "ask to update automatic links" in tools|options, but that will enable that behavior for only me. I'd like the user to not need to click "update links" every time they open the workbook, as they already need to enable macros. Thanks in advance, tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links automatically when opening file
Hi Tim
Put this in the ThisWorkBook module but be aware this setiing is an application wide setting and for that reason when the wbook is closed the setting should be restored to the users own preference. hth Geoff Option Explicit Dim bWbAskLinksOn As Boolean Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.AskToUpdateLinks = bWbAskLinksOn End Sub Private Sub Workbook_Open() With Application bWbAskLinksOn = .AskToUpdateLinks .AskToUpdateLinks = False End With End Sub "Tim Otero" wrote: This one's got me stumped. I'd like to be able to bypass the update links dialog box when opening a file. I know I can do this by unclicking "ask to update automatic links" in tools|options, but that will enable that behavior for only me. I'd like the user to not need to click "update links" every time they open the workbook, as they already need to enable macros. Thanks in advance, tim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links automatically when opening file
Geoff wrote:
Hi Tim Put this in the ThisWorkBook module but be aware this setiing is an application wide setting and for that reason when the wbook is closed the setting should be restored to the users own preference. hth Geoff Option Explicit Dim bWbAskLinksOn As Boolean Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.AskToUpdateLinks = bWbAskLinksOn End Sub Private Sub Workbook_Open() With Application bWbAskLinksOn = .AskToUpdateLinks .AskToUpdateLinks = False End With End Sub "Tim Otero" wrote: This one's got me stumped. I'd like to be able to bypass the update links dialog box when opening a file. I know I can do this by unclicking "ask to update automatic links" in tools|options, but that will enable that behavior for only me. I'd like the user to not need to click "update links" every time they open the workbook, as they already need to enable macros. Thanks in advance, tim Thank you Geoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links without opening other files | Excel Programming | |||
Update links automatically | Excel Programming | |||
automatically update links without opening file | Excel Worksheet Functions | |||
Hide prompt to automatically update links on workbook opening | Excel Programming | |||
Update Links automatically using VBA ? | Excel Programming |