Startup Prompt to update Links
Werner Rohrmoser wrote:
When I go to "Edit" = "Links" = "Startup Pompt" I can select
"Don't display the alert and update links".
But the alert is always displayed when I start a file with such a
configuration.
I think that option is broken.
If you are able to have macros within the file, I suggest you set it to
Don't display the alert and don't update links.
Then have the Workbook_Open macro update the links.
In ThisWorkbook module
Private Sub Workbook_Open()
Dim vLinkSources
Dim iLinkSource As Integer
vLinkSources = ThisWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(vLinkSources) Then
For iLinkSource = LBound(vLinkSources) To UBound(vLinkSources)
ThisWorkbook.UpdateLink vLinkSources(iLinkSource), xlExcelLinks
Next
End If
End Sub
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|