You could set the hyperlink to the cell with the hyperlink. Then use the
followHyperlink event to do what you want.

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
I have a macro in my workbook that returns a(ll) hyperlink(s) to the
requested Word document(s) using the ActiveCell.Text as the document name.
It works great - except now I have to apply it to a bunch of .txt files.
These open in Notepad - I need Word for functionality when the document is
open.

Is there a way I can set a "When Clicked" event so that, when one of these
hyperlinks is clicked on, a macro will launch Word and open the selected
file? I'd probably have to remove the hyperlink formatting, I think, so
my
returned file name could be used as the doc name.

Am I asking too much? Is there an easier way?

Ed