Detecting broken hyperlinks

I've searched on here - could not find anything that works for me.

I have a worksheet which contains a listing of hyperlinked cells to local files.

What is the best way of detect broken links to the file (i.e. missing file etc) and to output this to a cell next to the link, i.e. LIVE / DEAD

Many thanks

Yes that was the one I tried and did not do anything for me.

When testing this, I have purposely put in invalid link to a file (which was named incorrectly) but the link you provided did not change the text to yellow or anything.

Was there anything else I am supposed to do?

Thanks

Hmm wonder why did it not work for me.

Yes I did select the cell containing the following:

=HYPERLINK("\docs\rename.txt","THE FILE")

The actual document is in "rename.txt" without the 'docs' folder.

Originally Posted by AlphaFrog

That code doesn't work for hyperlink formulas. It only works for hyperlink objects that where created by Insert\Hyperlink. Can you use the hyperlink object instead of the HYPERLINK formulas?

Ah - thats why it never worked.

I create a long list of the formulas taking values from other cells so it has to be formulas rather than insert hyperlink object

Originally Posted by AlphaFrog

This should test HYPERLINK formulas.

Please Login or Register  to view this content.

This works for me - but it also highlight yellow for all cells that contained the hyperlink formulas regardless if it's a live/broken links

Do the script check the connection to a file and highlight those that either have incorrect path/file names or the file that may be missing?

It's just that this script only highlight any hyperlink in yellow.