Edit All Hyperlink URLs

[Rebecca]

Greetings. Is there an hotkey / keystroke combination whereby I can open all
hyperlinks and then using search and replace edit the URLs? This will come
in handy when I have to move files and folders around, esp. computer to
computer. Thanks. I hope to G-d I don't have to write a macro because it's
something I am unable to do.

 

[Dave Peterson]

If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)


If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[Rebecca]

Thanks, Dave, and yes, there will be a lot of them eventually. In MS Word
2007 there is an easy way to do this, but I guess that's not the case in
Excel 2007.