Automatically accepting msgs

[Guest_imported]

Good Morning - I have a workbook which contains automatic links. So, when I start the workbook it says, "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"

I always click Yes. Is there anyway to automatically do this?

 

[Loomah]

Good Morning, Chodo

Try adding this code to the workbook(s) containing the links:

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub