global changes to hyperlinks?

N

nickle

Hello..
can any kind people out there help me
find out how to apply global change (or any
other way beside doing each hyperlink individually)
of address path of all of the hyperlinks
in the spreadsheet?

Thanks..
 
C

CLR

I had a similar problem last month, and Leo Heuser gave me a slick macro
solution. It's over my head but I was able to follow his instructions and
implement it and it worked super..........check the
microsoft.public.excel.links newsgroup, for the thread "How can I change
multiple Hyperlinks?" starting on August 7th, last month. If for some
reason you can't get it, drop me an email and I'll send you copies of his
code and comments.....

Thanks again Leo........

Vaya con Dios,
Chuck, CABGx3
 
N

nickle

Thanks David!
-----Original Message-----
The thread mentioned by Leo can be seen in Google Groups
after doing a search. Look at the entire thread because
if think Leo modified code later in the thread.

http://google.com/groups?selm=uMuk74YXDHA.2204% 40TK2MSFTNGP12.phx.gbl
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I had a similar problem last month, and Leo Heuser gave me a slick macro
solution. It's over my head but I was able to follow his instructions and
implement it and it worked super..........check the
microsoft.public.excel.links newsgroup, for the thread "How can I change
multiple Hyperlinks?" starting on August 7th, last month. If for some
reason you can't get it, drop me an email and I'll send you copies of his
code and comments.....

Thanks again Leo........

Vaya con Dios,
Chuck, CABGx3
Click to expand...


.
Click to expand...
 
Top