Find broken hyperlinks and highlight them

Hi,

I need a macro that will search an entire workbook and highlight hyperlinks that direct you to an external website (SkyDrive) that don't work.

Thanks in advance!!

Sim

hi SIM.SIM, welcome to Excelforum, can you post a sample workbook to support your question?

try this option:

To my understanding broken link is:
- text string that is not a link
- a valid link but leads to "Not found" page

Please Login or Register  to view this content.

This works brilliantly thank you watersev!