Creating a Link to defined area within thesame document / different tab.

[ReveillePost]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)

I am trying to create a link on a master grid that will take the viewer to a defined location within another tab. I can get it to work on my own computer by using the Hyperlink / Anchor method. However it will only work on my computer due to the defined file path it creates. (Essentially working like a electronic table of contents, click on heading and it takes you to another defined area of that document to view) Is there a way to do this so the excel document is able to be sent to another persons computer (which changes file path)?

Any help would be hugely appreciated. Thanks

 

[CyberTaz]

Although it may be possible, why not just use a Named Range. If you wish,
attach a Comment containing instructions to the cell(s) that would otherwise
be the hyperlinks. The range name would be readily accessible from the Name
Box in the Formula Bar regardless of where in the workbook one might happen
to be whereas you have to be where a hyperlink is in order to use it.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[ReveillePost]

I appreciate the quick response. Wont quite work for the target audience for this, a bit more complex than I can ask of them. Was just hoping there was an easy fix to the link address that would tell it to look at the document itself instead of trying to route it through the computer its coming from (HD > USERS > DOCUMENTS > XLS FILE etc...) to find the document / Anchor point.

Thanks

Although it may be possible, why not just use a Named Range. If you wish,
attach a Comment containing instructions to the cell(s) that would otherwise
be the hyperlinks. The range name would be readily accessible from the
Name Box in the Formula Bar regardless of where in the workbook one might
happen to be whereas you have to be where a hyperlink is in order to use
it.





HTH |:>) Bob Jones [MVP] Office:Mac

Version: 2004 > Operating System: Mac OS X 10.4 (Tiger) > > I am trying

to create a link on a master grid that will take the viewer to a > defined
location within another tab. I can get it to work on my own computer >
by using the Hyperlink / Anchor method. However it will only work on my

computer due to the defined file path it creates. (Essentially working

like a > electronic table of contents, click on heading and it takes you
to another > defined area of that document to view) Is there a way to
do this so the excel > document is able to be sent to another persons
computer (which changes file > path)? > > Any help would be hugely appreciated.
Thanks

 

[CyberTaz]

Hello again -

<snip>

Wont quite work for the target audience for this

<snip>

Oh, sure it will - better, in fact... At least if they're using anything
but Excel 2008.

Plaster a button onto your starting sheet (using the Forms toolbar) &
simultaneously record a macro that navigates to the range. Label the button
even more explicitly than a hyperlink would be.

You may be able to do the same with XLM so that it will even work in 2008,
but I'm not sure about that - haven't used it in too long

HTH |:>)
Bob Jones
[MVP] Office:Mac