Hyperlinks

[Guest]

I am using hyperlinks to go to a destination in another worksheet in the same workbook. I would like the target cell to display in the center, left of the screen. In general, most are displayed at the bottom of the screen
Is there any nice way to do this?

 

[jeff]

Hi,

If I'm understanding you correctly, you want the target
to be positioned to look good on the screen.

You might play with this macro I threw together which
recentered the targets of an "index"-like setup.
It's the 'ActiveWindow.ScrollRow = 80' that's the key.

jeff


Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target = "Transportation:" Then ActiveWindow.ScrollRow
= 36
If Target = "Telecommunication:" Then
ActiveWindow.ScrollRow = 80
End Sub

-----Original Message-----
I am using hyperlinks to go to a destination in another

worksheet in the same workbook. I would like the target
cell to display in the center, left of the screen. In
general, most are displayed at the bottom of the screen.