Verifying Hyperlinks in Excel

[diamondcat]

I have a sheet in Excel that has 3000 drawings listed on it. When you click on the drawing name, a tif image of that file will come up by using simple hyperlinks. The problem is that we shipped the main Excel file and all of the drawing files to our customer and he says that some of the files cannot be located but he cannot tell us which ones. Is there a way in Excel 2000 to verify all of the hyperlinks without clicking on each one?
I'd appreciate any help I can get.
Thanks,
Lori

 

[MintJulep]

Seems like this could be done using the fileexists method from VBA.

 

[diamondcat]

Sorry, I am not familiar with VBA. I was hoping to find some kind of command already in Excel to verify the links. It seems like something that should be in there.
Thanks anyway,
Lori