hyperlink
 

How do I get the worksheet to place the hyperlinked target cell in the A1
position, when I jump to the section I want on a computer with a smaller
screen I loose the left/upper area--
Carl in Vegas

hyperlink
 

Hi Carl:

This may belp.

Let's say we have a hyperlink in cell A1 that takes us to cell Z100. Insert
this tiny Event macro in the Worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Dim s As String
s = ActiveCell.Address(ReferenceStyle:=xlR1C1)
Application.Goto Reference:=s, Scroll:=True
End Sub

After installing this, hyperlink jumps will go to the correct cell and that
cell will be positioned in the upper left-hand corner (the A1 position).

REMEMBER: the worksheet code area, not a standard module.
--
Gary''s Student - gsnu200743


"Carl" wrote:

How do I get the worksheet to place the hyperlinked target cell in the A1
position, when I jump to the section I want on a computer with a smaller
screen I loose the left/upper area--
Carl in Vegas