Excel 2003 - hyperlink to a location in the same file
 

When I create a hyperlink to a location within the same Excel 2003 file, it
goes to that location, but often, the location appears at the bottom of the
screen and then I have to scroll down to see the rest of the information
below the hyperlink.

Is there a way to have the hyperlinked location automatically appear at the
top of the Excel screen when you hyperlink to it?

Excel 2003 - hyperlink to a location in the same file
 

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

This is sheet event code. Right-click on the sheet tab and "View Code".

Copy/paste the code into that module.

A click on a hyperlink will bring the destination cell to top left of sheet.


Gord Dibben MS Excel MVP


On Mon, 29 Jun 2009 08:08:01 -0700, Silverstreak
wrote:

When I create a hyperlink to a location within the same Excel 2003 file, it
goes to that location, but often, the location appears at the bottom of the
screen and then I have to scroll down to see the rest of the information
below the hyperlink.

Is there a way to have the hyperlinked location automatically appear at the
top of the Excel screen when you hyperlink to it?