hyperlink in cell
Thanks Tom.
--
"Tom Ogilvy" wrote:
I can't say why, but try using the Hyperlink worksheet function
=Hyperlink("\\Server\Folder_level1\subfolder_level 2\subfolder_level3\subfold
er_level4\,"Friendly Text")
--
Regards,
Tom Ogilvy
"Ben" wrote in message
...
Hi all,
I am not sure I quite understand why, but I tried to place a hyper link in
a
cell in the form of UNC path to a network server folder, it would loses
the
link. I have it in the following format:
\\Server\Folder_level1\subfolder_level2\subfolder_ level3\subfolder_level4\
When I click on the link, it would give this message "The address of this
site is not valid. Check the address and try again." But after I repaste
the UNC path to the Address textbox, it would work again. This keeps on
happen, even after I saved the link immediately after I repasted the UNC
path
tothe address textbox.
Any idea why it keeps losing the linkage? Any suggestions? Thanks in
advance.
Ben
--
|