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

A

andres a

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Cut/Copy/Paste in Excel 2010 0
XL03: Avoid "workbook contains links" msg when opening 6
macro triggered by changes to cell only works if i run it twice 3
Last used cell problem 3
Copying data into a number of other workbooks 0
Listbox displaying incorrectly on opening worksheet 3
multiple conditions for if then else 2
SaveCopyAs and Overwrite Alert 5

Top