Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink troubles
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink troubles
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),sheeton e!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. jw4774 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubles | Excel Discussion (Misc queries) | |||
Pie Chart Troubles | Charts and Charting in Excel | |||
Formula troubles | Excel Discussion (Misc queries) | |||
COM Add-in Troubles | Excel Discussion (Misc queries) | |||
IF troubles | Excel Worksheet Functions |