| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the worksheet tab name updates hyperlink on first page?
The subject essentialy is what I want to accomplish. Also if when I update
the tabs (rename or add a new one) the list of hyperlinks adjusts automatically? If it needs to work the other way around that would be ok as well. (hyperlink edits result in tab name edits and/or additional tabs) thanks for the help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change the worksheet tab name updates hyperlink on first page?
The best way to create an internal hyperlink (to another place in the
workbook) is to assign a Name to the destination and hyperlink to that Name. Then you can change tab names and all will be o.k. -- Gary''s Student - gsnu200746 "excel-chump" wrote: The subject essentialy is what I want to accomplish. Also if when I update the tabs (rename or add a new one) the list of hyperlinks adjusts automatically? If it needs to work the other way around that would be ok as well. (hyperlink edits result in tab name edits and/or additional tabs) thanks for the help! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change the worksheet tab name updates hyperlink on first page?
Gary''s Student,
It took me a little while to figure out how to get it to work the way I needed it to (not for how you explained it but for my own lack of inderstanding in Excel) work, but I got it working great now! Thank you so much for giving me direction. excel-chump "Gary''s Student" wrote: The best way to create an internal hyperlink (to another place in the workbook) is to assign a Name to the destination and hyperlink to that Name. Then you can change tab names and all will be o.k. -- Gary''s Student - gsnu200746 "excel-chump" wrote: The subject essentialy is what I want to accomplish. Also if when I update the tabs (rename or add a new one) the list of hyperlinks adjusts automatically? If it needs to work the other way around that would be ok as well. (hyperlink edits result in tab name edits and/or additional tabs) thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink Question -- Change in Worksheet Name? | Excel Worksheet Functions | |||
| How do I change one page to lanscape in an Excel worksheet? | Setting up and Configuration of Excel | |||
| set up a link that updates page one from all other page entries? | Excel Worksheet Functions | |||
| Hyperlink updates within same worksheet | Excel Discussion (Misc queries) | |||
| change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
![excel-chump[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
