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

Private Sub workbook_open()
un = Application.UserName
Select Case un
Case "xx1", "xx2", "xx3"
' if user is one of the above the prompt will not be
displayed
Application.DisplayAlerts = False
Case Else
Application.DisplayAlerts = True
' prompt will be displayed for other users
End Select

End Sub



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