View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.links
John Wirt[_5_] John Wirt[_5_] is offline
external usenet poster
 
Posts: 18
Default Writing a macro to change external links to manual updating in Excel 2000

Can a VBA routine be written to change external links to manual updating
after they have been initially created in a workbook and that workbook has
been closed?

I would like to write a VBA procedure that can be included in a workbook
template so that external links created in any workbooks created from the
template can be manually changed from manual to autmatic updating.

Is this possible?

John Wirt