So I have been searching the forum and only found the following code to bring
a hyperlinked cell to the top left of the window:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveWindow.ScrollRow = ActiveCell.Row
End Sub

Is there anyway to do this BETWEEN worksheets (above code works only for
hyperlinks within same worksheet). No matter how I've tried to manipulate
this code clicking on a link from another worksheet does not bring the linked
cell to the top left of the window. Any help would be appreciated! Thanks.