hide/auto select Automatic Links Dialog (Excel 2000) 1

[aarondewberry]

Everytime I log into a specific excel workbook, a dialog pops up saying "The workbook you opened contains automatic links..." and then asks me to select 'Yes' to update with changes made to other workbook or 'No' to keep existing info. Yes will be selected everytime so....
Is there code I can use on workbook_open() to automatically select yes everytime without seeing the dialog box??

 

[combo]

Set not to update links (Edit>Links), in ThisWorkbook module add

Private Sub Workbook_Open()
Me.UpdateLink Name:=ThisWorkbook.LinkSources
End Sub

combo

 

[aarondewberry]

Combo

The only options I have in (Edit>Links) is Update Now, Open Source, Change Source. How do I set not to update links?

 

[combo]

At least in xp there's a button on the bottom-left of the 'links' dialog, however its caption is rather messy...

combo