How do I create relative hyperliks inside Excellworkbook ? Sweden

  • Thread starter Crop Protection
  • Start date
C

Crop Protection

Hi ("Hej" in Swedish)

When inserting hyperlink on sheet1 to sheet3 A5 and then adding a new row
above A5 at sheet3 the link stays at A5, but I want it to "follow" orgin cell
A5 (now cell A6).

Anyone out there....?
 
D

Dave Peterson

Instead of using Insert|hyperlink, maybe you could use the =hyperlink()
worksheet function:

David McRitchie posted this and it might help you:

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


If you really want to stick with the Insert|hyperlink version, you could give
your target cell a nice range name (Insert|Name|define), then use that when you
create the hyperlink.
 
Top