hyperlink to top left 'between' worksheets
Think I found the problem actually. I neglected to mention that the
hyperlinks are not in cells--they are clipart. So if I put in the below code
in the worksheet with the clipart, the linked cells on the other worksheet do
not go to the top of the page.
Any workaround?
"dgold82" wrote:
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.
|