Cydkil wrote:
It is more manual as we have many links to other file types in different
directories which requires typing or opening an explorer window and copying
and pasting the location from the address bar.


If you use my suggested approach in the last message, the only addition to
what you were doing previously to create the links would be: highlighting a
range of cells into which you had added hyperlinks and clicking a button to
run the macro - not a huge overhead I would have thought.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup