If you're specific about your hyperlinks....then you could engage the
Hyperlink.Follow event to position the referenced cell in the upper left.
Here's how:
• Right-click the sheet tab
• Select: View Code
That will bring you to the Visual Basic Editor (VBE) code module for that sheet
• Copy the below code and paste it into the VBE module
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto Reference:=ActiveCell, Scroll:=True
End Sub
Now...whenever you click a hyperlink on that sheet, the target cell will be
positioned in the upper left.
Is that something you can work with?
Bookmarks