View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BoobyD BoobyD is offline
external usenet poster
 
Posts: 1
Default Excel Hyperlinks

How can you amend a number of hyperlinks where the location has changed but
the actual page name hasn't. E.g. file:\\fred\page01 all the links are now on
John, file:\\john\page01, 02, 03 etc.
It seems from what I see that there is only a one at a time method.
Does it require a macro?