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