How to make Excel 2002 to automatically update worksheet names in hyperlinks?

  • Thread starter Thread starter Dmitriy Kopnichev
  • Start date Start date
D

Dmitriy Kopnichev

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.
 
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
(e-mail address removed)
 
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),sheetone!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.)
 
Back
Top