View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jose Rojas Jose Rojas is offline
external usenet poster
 
Posts: 16
Default 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.