Linking to an area within another sheet

[skoorBmaS]

I am trying to make a summary sheet link to other sheets within the workbook via the use of a hyperlink. Within the different sheets, I have certain headings which I would like to link to. The way I have gone about this is to designate the cell with a name and then use that name as the hyperlink destination. When I click the hyperlink, I would like that cell to always be selected and at the top of the screen, however depending on where the cell is within the sheet, the cell may not automatically be centered to the at the top of the screen. Does anyone know any way around this?

 

[James_Latimer]

You could try adding this code to the worksheet that you're clicking the links on...

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