Window Movement

[Guest]

If I activate a hyperlink on one sheet to a cell on another sheet, the target
cell is shown in the lower right corner of the window. How can I make the
window display the active cell in the top left of the window?

I had considered using the activate sheet event to control the screen
movement but how do I determien the scroll required?

Thanks

 

[Ken Johnson]

If I activate a hyperlink on one sheet to a cell on another sheet, the target
cell is shown in the lower right corner of the window. How can I make the
window display the active cell in the top left of the window?

I had considered using the activate sheet event to control the screen
movement but how do I determien the scroll required?

Thanks

Hi,

Try this code in the code module of either the sheet with the hyperlink
of the sheet the hyperlink takes the user to..

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

Ken Johnson

 

[Guest]

Works Great
Thanks

Hi,

Try this code in the code module of either the sheet with the hyperlink
of the sheet the hyperlink takes the user to..

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

Ken Johnson

 

[Ken Johnson]

You're welcome Nigel.
Thanks for the feedback.

Ken Johnson