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