If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What hyperlink method if any supports target rename?
I want to have several hyperlinks to the same external file on my hard
disk. And I want to be able to move or rename the file at will. I accept that, on renaming the file, I'll also rename its hyperlink target in Excel. BUT, I only want to rename the target ONCE in Excel. I refuse to rename EVERY Excel hyperlink to it. If I use function =HYPERLINK(target), and if target is, say, a range name pointing to a formula, then whenever I rename target, all hyperlinks to it will update. But that is NOT TRUE if I use Excel's native hyperlink dialog, invoked thru Insert / Hyperlink. With it, you evidently give a cell GREATER functionality than you do with mere function =HYPERLINK()--see 9/17/2007 thread "When is =HYPERLINK() not a hyperlink?" So my question: Using Excel's NATIVE hyperlink capability (NOT =HYPERLINK() function), can hyperlinks be created so that a rename of the file requires only ONE rename as a hyperlink target in Excel? Thanks. *** |
#2
|
|||
|
|||
What hyperlink method if any supports target rename?
Using Excel's NATIVE hyperlink capability (NOT
=HYPERLINK() function), can hyperlinks be created so that a rename of the file requires only ONE rename as a hyperlink target in Excel? I don't believe so. I would write a macro to change them all. Such functionality is included in my LinkManager utility, but it is aimed more at changing links in all workbooks in a directory structure when moving a source directory. However you are welcome to try it (it's free!) Just email me at Bill underscore Manville at Compuserve dot com Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|