Select cell top left corner hyperlink

[cfer]

Hi,

I have a hyperlink that I have, cell refernced to go to is A560.

When I clivk the hyperlink. it goes to that cell, but it is 2 thirsd down the screen.

How can I make sure each time that cell A560 is in the uppermost left hand corner each time.

Thanks in advance
Cfer

 

[Andrew Poulsom]

Put this in the module for the worksheet containing the hyperlink:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    Application.Goto ActiveCell, True
End Sub

 

[cfer]

Hi,

Thanks, Worked