software

Hi,

When putting an Hyperlink in an Autoshape, he returns the hyperlink cell at
the bottom of the page.

I found a related message from 12/19/2005 that works perfectly when
hyperlinking in a cell, but this doesn't work in Autoshapes.

Can anyone help ?

Thanks,
Gecko


You should right click the Auto Shape and then click open hyperlink--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
View this thread: www.excelforum.com/showthread...hreadid=523511Indeed, but when I click it, the hyperlink cell is at the bottom of my sheet.

How can I get it at the top ?quot;dalipsinghbishtquot; wrote:

gt;
gt; You should right click the Auto Shape and then click open hyperlink
gt;
gt;
gt; --
gt; dalipsinghbisht
gt; ------------------------------------------------------------------------
gt; dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
gt; View this thread: www.excelforum.com/showthread...hreadid=523511
gt;
gt;

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

hth
Vaya con Dios,
Chuck, CABGx3
quot;Geckoquot; wrote:

gt; Indeed, but when I click it, the hyperlink cell is at the bottom of my sheet.
gt;
gt; How can I get it at the top ?
gt;
gt;
gt; quot;dalipsinghbishtquot; wrote:
gt;
gt; gt;
gt; gt; You should right click the Auto Shape and then click open hyperlink
gt; gt;
gt; gt;
gt; gt; --
gt; gt; dalipsinghbisht
gt; gt; ------------------------------------------------------------------------
gt; gt; dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=523511
gt; gt;
gt; gt;

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

quot;CLRquot; wrote:

gt; Right-click the AutoShape gt; Hyperlink gt; EditHyperlink gt; in the
gt; NamedLocationInFile: window, type the address you wish to go to.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Geckoquot; wrote:
gt;
gt; gt; Indeed, but when I click it, the hyperlink cell is at the bottom of my sheet.
gt; gt;
gt; gt; How can I get it at the top ?
gt; gt;
gt; gt;
gt; gt; quot;dalipsinghbishtquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; You should right click the Auto Shape and then click open hyperlink
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; dalipsinghbisht
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=523511
gt; gt; gt;
gt; gt; gt;

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

quot;Geckoquot; wrote:

gt; When I click the link, it jumps to the correct cell, but it is at the bottom
gt; of the screen, not the top.
gt; So I then have to scroll down to view the rows.
gt;
gt; I want it so when the link is clicked the cell to which it is linked is
gt; displayed at the top of the screen.
gt;
gt; Cheers,
gt; Gecko
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Right-click the AutoShape gt; Hyperlink gt; EditHyperlink gt; in the
gt; gt; NamedLocationInFile: window, type the address you wish to go to.
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Geckoquot; wrote:
gt; gt;
gt; gt; gt; Indeed, but when I click it, the hyperlink cell is at the bottom of my sheet.
gt; gt; gt;
gt; gt; gt; How can I get it at the top ?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;dalipsinghbishtquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; You should right click the Auto Shape and then click open hyperlink
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; dalipsinghbisht
gt; gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; gt; dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
gt; gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=523511
gt; gt; gt; gt;
gt; gt; gt; gt;