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

I would like the user to select a directory and file and then use this
filename so that cells in the spreadsheet link to the selected file.
Basically once the user selects the file he needs the spreadsheet will
update all the cells relative to this chosen file. As the selected file could
be in different directories I don't want to tie the search to a single
directory, but rather let the user choose it.

Is there a simple solution?