Prevent Update Links Message

Re: Use Vb To Say No To Update Message

Should the file even have links to other sources? If not follow the steps in this thread to remove them, this will also eliminate the message.

http://www.ozgrid.com/Excel/ExcelProblems.htm

Re: Use Vb To Say No To Update Message

Hi

enter this code in This Workbook in the Project Explorer

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False


End Sub

HTH

Robert

Re: Use Vb To Say No To Update Message

If you DO have links the Workbook_Open Event will not help as it fires after the link message. See Updating Links