Hi, thanks for the fast help Dave.

What a relief, something that will work. Owe you a beer (Canadia
beer).


For the finishing touches;

1. Would you have a trick up your sleeve to retrieve the value (o
display text) of inserted/hyperlinks, instead of the HL.Address
which have already been trashed by the RHPD
...'Relative-Hyperlink-Path-Disease'. (I tried HL.value in you
macro - it blew up.) :)

The current resulting hyperlinks and display show:
file:///\\servername\..\..\sharename\filename.ext in my tes
files. (Obviously, I'll build a new test file from the operationa
workbook prior next tests.) ;)


2. For the display part of the =HyperlinkFormula, is there a way t
simply rip out the 'file:///' out of the display strings ?

3. Curiousity; Links used to work OK without using the -'file///'
pre-string. Is this pre-string a hold-over from previous versions o
Excell, or is it now essential for a reliable hyperlink jump of
=Hyperlink-Formulae ?

or, yet again, can it be safely be ripped out even off the hyperlin
itself ?


4. Goal is to get a clean display:
\\servername\sharename\filename.ext
and if possible, clean underlying hyperlinks as well... ... withou
RHPD ;)

Thank you

--
Electro91
-----------------------------------------------------------------------
Electro911's Profile: http://www.excelforum.com/member.php...fo&userid=3194
View this thread: http://www.excelforum.com/showthread.php?threadid=51708