Hyperlinks
Right
going to try out what you said - be back soon
--
D Rodman
"Bill Manville" wrote:
You still have the arguments wrong.
The FIRST argument of Hyperlink is the filename you want to link to.
The second argument is what appears in the cell.
=HYPERLINK("C:\Temp\MyFile.doc", "My File") will show My File in the
cell, in hyperlink format, and will link to the file specified when you
click the cell.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|