hyperlink troubles

J

jw4774

how can you programatically move hyperlinks keeping the relative references,
so that the hyperlink is recreated when it is moved.

I have tried using the copy and paste hyperlink but this doesn't alter the
link for the change in location when the workbook is in a different directory
to the intial workbook that it is copied from.

Thanks
 
D

Dave Peterson

Does this mean you want to point at the new workbook?

If yes, then I'd 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)

======
But if I insert a hyperlink (using ctrl-k) and then point to a place in this
document, it seems to follow the workbook nicely.

If that's not happening for you, you may want to explain how you added the
hyperlink and what you're doing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top