Global Replacement of Test to Display
 

I have a large number of hyperlinks previousely created in worksheets in a
form the text to display is always different from its actual address. Now I
am looking for a 'programable' way to replace all the text to display with
their actual addresses, rather than manually change it one at a time by
editting the hyperlinks using GUI. Your knowledge and experience will be
greatly appreciated. Thanks you very much.