Repositioning after hyperlink.....
On Tuesday, April 21, 1998 3:00:00 AM UTC-4, Richard Meimoun wrote:
Hi there !
I've made a hyperlink on D1 and is pointing to A200 but on the same sheet.
My question is how can I make the cell A200 the top left corner of my sheet
?
Thanx in advance.
Use the FollowHyperLink event on the sheet with the hyperlink
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveWindow.ScrollColumn = ActiveCell.Column
ActiveWindow.ScrollRow = ActiveCell.Row
End Sub
|