Hyperlink Question -- Change in Worksheet Name?

[BG]

I am looking to see if there are any "Table of Content" or "Price List"
Templates. I currently have a workbook with 3 worksheets (List of items,
Index, Table of Contents). I'm looking for something where I can link cells
in one worksheet to jump to cells of another worksheet. I attempted to use
links, linked several cells, and then decided to change the name of the
worksheet I had linked to. Is there a quick fix for this? any suggestions
welcome.

 

[Norm]

You can achieve this with a Hyperlink that refers to a Defined Name range.
When you change the name of the worksheet, the Defined Named also changes to
the new worksheet name so the Hyperlink continues to function properly.
Example below for Excel 2003.

First, define a name for one of the the cells that you want to jump to (from
Excel menu, select Insert - Name - Define). In your Table Of Contents,
place the cursor on a cell and insert the hyperlink (from Excel menu, select
Insert - Hyperlink). This opens the Insert Hyperlink dialogue box. In the
centre window, you will see a list of defined names. Select the one you just
created. Change the Text to Display box to how you want it to show up in
your Table Of Contents then click OK. Done!

Good luck!