Window Movement
 

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

Window Movement
 

Nigel RS wrote:

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

Window Movement
 

Works Great
Thanks

"Ken Johnson" wrote:

Nigel RS wrote:

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

Window Movement
 

You're welcome Nigel.
Thanks for the feedback.

Ken Johnson