Hyperlinks Only Work After Manual Edit

I have received from reading previous posts in this forum. Now I have a problem that I have struggled with for weeks. Ref: Excel 2000. I create (Purchase Order) Workbooks with 50 (POs) Worksheets, and 1 summary (Index) worksheet. The Index worksheet has hyperlinks to each PO (created via VBA), and works as expected.
Subsequently, each worksheet has a hyperlink back to the Index worksheet also created from VBA

Sheets(Counter + 2). Cells(2, 2).Select
ActiveSheet.Hyperlinks.Add Anchor:=Sheets(Counter + 2).Cells(2, 2), _
Address:="", SubAddress:=Sheets(PONumber & " THRU " & PONumber + 49) _
.Cells(Counter + 3, 1).Address

Before the hyperlink in each worksheet will work I must (with the cell containing the hyperlink selected) either right-click|Hyperlink|Edit Hyperlink then press "Enter", or pres Ctrl-K (which brings up the edit dialog) and then press "Enter." If I don't manually edit each hyperlink on each worksheet these hyperlinks select the targeted cell on the same worksheet as the selected cell, not the targeted cell on the Index worksheet. Note, when I manually edit each hyperlink I am not actually making any changes to the hyperlink (thought something is obviously happening that I am unaware of), I am only accessing the edit dialog box.