(Solved) – Scroll from hyperlink event

(solved)-–-scroll-from-hyperlink-event

simple question that I am stuck with. I am trying to set a function that scrolls the active cell to the top of the screen and then selects that entire row (to make it 100% obvious what data to look at)

However this is doing nothing, how do I fix that?

Sub FollowHyperlink(ByVal Target As Hyperlink)

    ActiveWindow.SmallScroll up:=2

    ActiveCell.EntireRow.Select

End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *