Good morning all,

I'm working right now with a document that contents a lot of formulated hyperlinks, some of the original files where named by a coworker an there is the possibility that some of them weren't named right, so i need to check which ones of the formulated hyperlinks aren't working; i found a similar thread in this forum, but unfortunately the macro they used as a solution wasn't working for me, because my links are formulated.

here is the thread i found

http://www.excelforum.com/showthread.php?t=760760

I hope you can help this guy who only knows the basics in VBA, thank you all for your help.