Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HyperLinks
How do I program the hyperlinks to be relative? In other words, I have
hyperliks programmed for other tabs of the same workbook. When I insert a new row or rows, the cell definition in the actual hyperlink on the Table of Contents tab does not change. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HyperLinks
If you are hyperlinking to a cell in the workbook (either in the current
sheeet or not), the easiest way to make the destination relative is to assign a Defined Name to the destination and hyperlink using that destination. This will work using either Insert Hyperlinks or the =HYPERLINK() function -- Gary''s Student - gsnu200810 "Jerry Foley" wrote: How do I program the hyperlinks to be relative? In other words, I have hyperliks programmed for other tabs of the same workbook. When I insert a new row or rows, the cell definition in the actual hyperlink on the Table of Contents tab does not change. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HyperLinks
Thanks,
How exactly do I do that? Is the definition in the cell I am hyperlinking to? I was just trying to edit the hyperlink and where it says type in cell reference I was using the $ before the cell and number i.e. $c$123. Any help would be apprciated. Jerry "Gary''s Student" wrote: If you are hyperlinking to a cell in the workbook (either in the current sheeet or not), the easiest way to make the destination relative is to assign a Defined Name to the destination and hyperlink using that destination. This will work using either Insert Hyperlinks or the =HYPERLINK() function -- Gary''s Student - gsnu200810 "Jerry Foley" wrote: How do I program the hyperlinks to be relative? In other words, I have hyperliks programmed for other tabs of the same workbook. When I insert a new row or rows, the cell definition in the actual hyperlink on the Table of Contents tab does not change. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HyperLinks
Hi,
Highlight the cell or range to which you want to hyperlink and then Insert name Define. Once you have done so, the name will appear in the Hyperlinks dialog box. Now while you are on the cell which has to be a hyperlink, press Ctrl+K. In the white box to the right, you will see 2 broad categories. Just go to the Defined names category and select the name. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jerry Foley" wrote in message ... Thanks, How exactly do I do that? Is the definition in the cell I am hyperlinking to? I was just trying to edit the hyperlink and where it says type in cell reference I was using the $ before the cell and number i.e. $c$123. Any help would be apprciated. Jerry "Gary''s Student" wrote: If you are hyperlinking to a cell in the workbook (either in the current sheeet or not), the easiest way to make the destination relative is to assign a Defined Name to the destination and hyperlink using that destination. This will work using either Insert Hyperlinks or the =HYPERLINK() function -- Gary''s Student - gsnu200810 "Jerry Foley" wrote: How do I program the hyperlinks to be relative? In other words, I have hyperliks programmed for other tabs of the same workbook. When I insert a new row or rows, the cell definition in the actual hyperlink on the Table of Contents tab does not change. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HyperLinks
Suppose you want to jump to cell C25 in Sheet2 - you could have a
formula like this somewhere in Sheet1: =HYPERLINK("#Sheet2!C"&ROWS(Sheet2!A1:A25)) and this will show "#Sheet2!C25" in the cell, which if you click on it, will take you to that cell. Now if you insert, say, four new rows in Sheet2 somewhere between row 1 and row 25 then the formula will automatically adjust and the cell will show "#Sheet2!C29", and that's where you will jump to. However, if you insert rows after row 25 then the formula will not change - I think this is what you wanted. Inserting rows in Sheet1 will have no effect (other than maybe moving the formula down). Hope this helps. Pete On Oct 29, 9:21*pm, Jerry Foley wrote: How do I program the hyperlinks to be relative? In other words, I have hyperliks programmed for other tabs of the same workbook. When I insert a new row or rows, the cell definition in the actual hyperlink on the Table of Contents tab does not change. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |