View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nx3 nx3 is offline
external usenet poster
 
Posts: 8
Default Follow hyperlink but don't update links....is it possible ?

I have a long list of hyperlinks to files with the files have many links to
other files. I'm trying to open the files but not update the links in the
files as it slows the process down way to much. I thought the code would be
as follows but it doesn't work. Any idea ? tia.

Application.DisplayAlerts = False
ActiveCell.Hyperlinks(1).Follow
Application.DisplayAlerts = True