Hi,
I have the following code to show the cell location at top of page, but it hides column "A" as well becuase my hyperlink cell location is column "B".
Is there any amendment to following code to show column "A" as well.
Code -
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto Reference:=ActiveCell.Address(ReferenceStyle:=xlR1C2), Scroll:=True
End Sub
Thanks
I have the following code to show the cell location at top of page, but it hides column "A" as well becuase my hyperlink cell location is column "B".
Is there any amendment to following code to show column "A" as well.
Code -
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto Reference:=ActiveCell.Address(ReferenceStyle:=xlR1C2), Scroll:=True
End Sub
Thanks