How to write VBA

[March]

I would like to write VBA instead of the description below:

If I have an Excel file to open with the Warning Security like

"This Workbook contains linked to other data sources.
- To update all linked info, click Yes,
- To keep the existing info, click No.",

how wirte the VBA code to get rid of above Msgbox.


Thanks,

March

 

[Libby]

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

 

[March]

Thanks.

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