Mac Forum / Applications / Excel / July 2008

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

On 7/1/08 9:42 PM, in article 59b52ef6.-1@webcrossing.caR9absDaxw,

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

     On 7/1/08 9:42 PM, in article 59b52ef6.-1@webcrossing.caR9absDaxw, "ReveillePost@officeformac.com"
     wrote:

     > 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