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

C

Chong Moua

Hi Wellie,

Try this...
---------------------------------
Private Sub Workbook_Open()

ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
If Application.UserName = "MyName" Then UpdateLink _
Name:=LinkSources

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

Macro to Update links on a network 4
why won't this work? 3
update links (ignore previous post same title) 2
workbook_open 4
Update Password Protected Links 1
input info when pasted in cells 5
File not found when opening 3
Open and Close Workbooks 2

Top