A couple of ways.........You can choose an AlternateTarget cell address for
the Hyperlink that is 27 rows below and maybe some 15 columns to the right of
the cell you want to appear in the upper left hand corner of the screen
(experiment here)..........or, you can create a RangeName that is full screen
size with your Target cell as the upper leftmost cell and then Hyperlink to
that RangeName instead of to the specific cell.

Vaya con Dios,
Chuck, CABGx3

"Gecko" wrote:

When I click the link, it jumps to the correct cell, but it is at the bottom
of the screen, not the top.
So I then have to scroll down to view the rows.

I want it so when the link is clicked the cell to which it is linked is
displayed at the top of the screen.

Cheers,
Gecko

"CLR" wrote:

Right-click the AutoShape Hyperlink EditHyperlink in the
NamedLocationInFile: window, type the address you wish to go to.

hth
Vaya con Dios,
Chuck, CABGx3



"Gecko" wrote:

Indeed, but when I click it, the hyperlink cell is at the bottom of my sheet.

How can I get it at the top ?


"dalipsinghbisht" wrote:


You should right click the Auto Shape and then click open hyperlink


--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=523511