Checking for broken hyperlinks to documents on harddisk and no websites

Good morning all,

I am putting together an excel document in which I have a a few thousand hyperlinks made with the HYPERLINK function to pictures on my harddisk.
I found a solution on this forum for "normal" hyperlinks but it doesn't work if the hyperlink is made with the Hyperlink function !

I want to find out which hyperlinks are not working. Now I do this one by one and each time looking if the excel pop up "file cannot be found" pops up or not.
But I am feeling like a monk in the "middle ages"

My question is, is there a way to automatically check a range of cells to ensure none of the links are broken, and if there are broken links, which ones they are by coloring them ?

Thanks for your support !

This code will change all cells with invalid HYPERLINK references to red fill. This is a permanent change, not conditional formatting.

This code has to make assumptions about how you are using HYPERLINK because it needs to parse the formula. It assumes that the first argument is a string. If instead you are referencing a cell, the code has to be different. I have tested this, but your file could be different.

Please Login or Register  to view this content.