How to write VBA
 

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

How to write VBA
 

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


"March" wrote:

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

How to write VBA
 

Thanks.


"Libby" wrote:

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


"March" wrote:

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