hyperlink checker VBA

Hello,

I know this has been brought up a million times but for some reason I cant get anything I have found so far to work.. I have 700 photos (on my computer not a URL address) linked into an excel spreadsheet along with other data of the photos. I have manually looked through and taken out certain photos (roughly 100) after plugging it into the spreadsheet. Now, I want to be able to highlight these broken links to make sure they aren't needed before i completely delete them from the spreadsheet. I have seen numerous vba programs so I know I am in the right area.

Please help!
Brandon

Hello,

Thanks for responding. For some reason this isnt working either. It appears to have ran but no hyperlinks are in red. I know there are links broken due to finding a random few as I click on them.

I open vba, paste code into the correct sheet, and run "ValidateHyperlinks". Please let me know what I am doing wrong. I am running excel 2010 if that makes any difference.

Thanks again,
Brandon

Hello,

Thanks for all the help this far! I am definitely getting closer with Leith's code. I can get it to work properly if I manually paste in the link [EX: =HYPERLINK("\\C\examplefolder\examplepicture",examplepicture)] but not if I have the hyperlinks bound from another cell [Ex: =HYPERLINK("\\C\examplefolder\examplepicture"&B3,B3)]. Is there anything I can do to make this work still?

Thanks again,
Brandon

Anyone have any ideas?

Thanks for the help,
Brandon