| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink: back to last worksheet | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| how do I add a 'web address' to a cell in excel with a hyperlink? | New Users to Excel | |||
| Copy Worksheet Tab Name into a cell address | Excel Discussion (Misc queries) | |||
| How do I get a hyperlink to track specific data in a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
