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
|