View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
March March is offline
external usenet poster
 
Posts: 34
Default 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