Hello,

A spreadsheet that we use on every job used to have a reference to a
component that wasn't even used by the VBA program.

Now when people are changing over to office 2003 the spreadsheet throws
an error "cant find referenced component"

Of course all that is required is to uncheck the reference but most
people don't know this

Any way to batch process all these files to see if they have the
reference and if so get rid of it?

Thanks for any suggestions

JM