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
|
|||
|
|||
How to make Excel 2002 to automatically update worksheet names in hyperlinks?
Hello
How to make Excel 2002 to automatically update worksheet names in hyperlinks? I added text to worksheet names, and hyperlinks on another worksheet stopped working. The hyperlinks reference to old worksheet names. Now, I have to manually change worksheet names in hyperlinks. |
#2
|
|||
|
|||
How to make Excel 2002 to automatically update worksheet names in hyperlinks?
Dmitriy
There is no automatic way of doing this. It could perhaps be accomplished with some coding but you are not missing a secret switch ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Dmitriy Kopnichev" wrote in message ... Hello How to make Excel 2002 to automatically update worksheet names in hyperlinks? I added text to worksheet names, and hyperlinks on another worksheet stopped working. The hyperlinks reference to old worksheet names. Now, I have to manually change worksheet names in hyperlinks. |
#3
|
|||
|
|||
How to make Excel 2002 to automatically update worksheet names inhyperlinks?
David McRitchie has posted these:
How about one of these that David McRitchie has posted: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) And one of those bottom two updates nicely when I change the name of the worksheet. (The difference between the 2nd and 3rd is the single quotes around the sheet name--they're required when your worksheet name contains spaces or all numeric.) Dmitriy Kopnichev wrote: Hello How to make Excel 2002 to automatically update worksheet names in hyperlinks? I added text to worksheet names, and hyperlinks on another worksheet stopped working. The hyperlinks reference to old worksheet names. Now, I have to manually change worksheet names in hyperlinks. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|