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

Hi Wellie,

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

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

End Sub
----------------------------------
Hope this helps...

Chong Moua

-----Original Message-----
I'd like ONLY to have the 'Update or Don't Update alert
window' to be prompted when opening a spreadsheet that
has
link to other spreadsheets base on who open it.

Can someone please show me some code on how to do this ?

Thanks for any help.
.