hyperlink a worksheet with no address
 

How do i create a hyperlink from one worksheet to another within the same
workbook but so the location of the file itself will not cause an error in
the link.
When i create a hyperlink, then it has the address: "c:\document and ..."
how do i create it without?

hyperlink a worksheet with no address
 

Try this :
=HYPERLINK("[yourworkbookname.xls]Sheet2!A1","whatyouwantdisplyed")

Give this a go and let me know how it works


--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=571254

hyperlink a worksheet with no address
 

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Steel Monkey wrote:

Try this :
=HYPERLINK("[yourworkbookname.xls]Sheet2!A1","whatyouwantdisplyed")

Give this a go and let me know how it works

--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=571254

--

Dave Peterson