Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink Question -- Change in Worksheet Name?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink Question -- Change in Worksheet Name?
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! "BG" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet change Macro Question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Worksheet Functions |