Hyperlinks with difference address refernces

[JustATheory]

Greetings,
I a macro that creates worksheets based on a list it also creates a list of hyperlinks to each worksheet and a hyperlink in the worksheet back to the Table of Contents. I don’t want the hyperlink in each worksheet refer to Cell A1. I want each worksheet’s hyperlink to tie back to the hyperlink for that work sheet. For instance Sheet5 would tie back to A5, Sheet7 would tie back to A7. So I’m looking for a way reference back to the table of contents cell, it’s actually been years since I’ve worked in VBA and I’m rusty.

I realize it is in the SubAddress section, I just am rusty of the reference back to TOC.

Thank you,

JustATheory

Code Example

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"AllQuestions!A1", TextToDisplay:="TOC"

 

[zelgar]

I don't know if you can specify the location. It looks like in '07, its in the cell the spreadsheet was last saved. Maybe you can do it with the later versions.