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!