How to disable 'Update alert' when open a spreadsheet has link to other XLS

[Chong Moua]

Hi Wellie,

Try this...
---------------------------------
Private Sub Workbook_Open()

ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
If Application.UserName = "MyName" Then UpdateLink _
Name:=LinkSources

End Sub