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.
.
|