G Guest Oct 8, 2004 #1 How can I hyperlink worksheets from one workbook to another workbook? Just the sheet not the entire workbook?
How can I hyperlink worksheets from one workbook to another workbook? Just the sheet not the entire workbook?
D Dave Peterson Oct 8, 2004 #2 One way is to use Insert|Hyperlink and use an address like: C:\My Documents\excel\book2.xls#'sheet two'!a1 (You'll have to include a range, too.) You could also use a worksheet formula: =HYPERLINK("#"&CELL("address",'C:\My Documents\excel\[book2.xls]sheet two'!C5), "click here") (all one cell)
One way is to use Insert|Hyperlink and use an address like: C:\My Documents\excel\book2.xls#'sheet two'!a1 (You'll have to include a range, too.) You could also use a worksheet formula: =HYPERLINK("#"&CELL("address",'C:\My Documents\excel\[book2.xls]sheet two'!C5), "click here") (all one cell)
G Gord Dibben Oct 8, 2004 #3 Al AFAIK, you can't. If you have a hyperlink on sheet1 of book1 to sheet4 or a bookmark of book2 and click on it, Book2 will open to sheet4 or the bookmark. What exactly are you wanting to do that would not involve opening the target workbook? Gord Dibben Excel MVP On Fri, 8 Oct 2004 12:15:02 -0700, "Al Kinnamon" <Al
Al AFAIK, you can't. If you have a hyperlink on sheet1 of book1 to sheet4 or a bookmark of book2 and click on it, Book2 will open to sheet4 or the bookmark. What exactly are you wanting to do that would not involve opening the target workbook? Gord Dibben Excel MVP On Fri, 8 Oct 2004 12:15:02 -0700, "Al Kinnamon" <Al
