hyperlinks

E

Eric

I am using hyperlinks in my workbook. If I change the name
of the workbook the hyperlinks will not work in the new
workbook. Is it possible to set up a hyperlink so that it
will automatically change it's address to the renamed
workbook? Thanks for your help.
 
D

Dave Peterson

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)
 
Top