Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit multpile hyperlinks
How do you edit multiple hyperlinks at the same time?
I have a massive spreadsheet where a tab name has been changed and I need to correct all associated links to that tab. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit multpile hyperlinks
David McRitchie has some code that you can use to change the hyperlinks:
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 Erika wrote: How do you edit multiple hyperlinks at the same time? I have a massive spreadsheet where a tab name has been changed and I need to correct all associated links to that tab. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit multpile hyperlinks
I don't understand this enough at this point for it to be useful. I will
have to save this and come back to it after a few more courses. "Dave Peterson" wrote: David McRitchie has some code that you can use to change the hyperlinks: 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 Erika wrote: How do you edit multiple hyperlinks at the same time? I have a massive spreadsheet where a tab name has been changed and I need to correct all associated links to that tab. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't edit hyperlinks | Excel Discussion (Misc queries) | |||
Can't edit hyperlinks | Excel Discussion (Misc queries) | |||
Can't edit hyperlinks | Excel Discussion (Misc queries) | |||
Edit Hyperlinks | Excel Discussion (Misc queries) | |||
Edit Hyperlinks | Excel Worksheet Functions |