search spreadsheet for 'xyz' as part of any hyperlink address
 

I have a workbook with 12 different spreadsheets inside and loads of
hyperlinks to a certain group of libraries all starting with the same high
level address.
This group of libraries have all been moved to a new high level address and
I've gone through all of them manually to change the address.
However, the only really safe way is a job which can check through all the
hyperlink addresses, eitherin the entire workbook or in one spreadsheet at a
time for any address which still contains the old library name.