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?
|