Hyperlink alignment

[bmars]

If I have a hyperlink that is set up to reference a cell in the same sheet, is there a way to make the referenced cell appear as the top left cell on the screen?

 

[Case_Germany]

Hi,

the following code into the worksheet in that the hyperlink is (right-click on for example Sheet1 and View Code):

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    Application.Goto ThisWorkbook.ActiveSheet.Range(Target.SubAddress), Scroll:=True
End Sub

Case_Germany

 

[bmars]

Thank you so much! It works perfectly!