How to disable 'Update alert' when open a spreadsheet has link to other XLS
Sub Auto_Open()
If Application.UserName = "You" then
Application.DisplayAlerts = False
End if
"wellie" wrote in 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.
|