N
Nigel
Hi All
I am trying to set up some hyperlinks for each cell in a range comprising
the names of a set of worksheets in the same workbook. The links are
established but the references fail to link to the worksheets. Help!!
I would also like to link to the sheet codenames not the names to protect
the links in case users change the sheet tabs. Codenames will be set to the
contents of the cell range.
Code so far......
With wbReport
For xr = 8 to 18
.Hyperlinks.Add Anchor:=.Cells(xr, 2), _
Address:=.Cells(xr, 2).Text, _
SubAddress:=.Cells(xr, 2).Text & "!A1", _
TextToDisplay:=.Cells(xr, 2).Text, _
ScreenTip:="Goto " & .Cells(xr, 2).Text & " Report"
Next xr
End With
I am trying to set up some hyperlinks for each cell in a range comprising
the names of a set of worksheets in the same workbook. The links are
established but the references fail to link to the worksheets. Help!!
I would also like to link to the sheet codenames not the names to protect
the links in case users change the sheet tabs. Codenames will be set to the
contents of the cell range.
Code so far......
With wbReport
For xr = 8 to 18
.Hyperlinks.Add Anchor:=.Cells(xr, 2), _
Address:=.Cells(xr, 2).Text, _
SubAddress:=.Cells(xr, 2).Text & "!A1", _
TextToDisplay:=.Cells(xr, 2).Text, _
ScreenTip:="Goto " & .Cells(xr, 2).Text & " Report"
Next xr
End With