Excel 2003 - hyperlink to a location in the same file


S

Silverstreak

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

Advertisements

G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top