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