Brian,
Thanks for the advice - using the Worksheet On_Change()
(or Workbook SheetChange()) the only issue I had with this is that the code
kicked off when any cell is changed regardless of whether or not it was a
link - having said this I know you can check whether or not the cell contains
a link but it seems a shame that you cannot just check for link updates only.
But thanks again.