I have a macro that uses an add-in (Solver). In order for the code to run, I need to go to VBEditor>Tools>References and select SOLVER. When a coworker opens it in Excel 2010, it won't work until he goes to Tools>References, deselects "MISSING_SOLVER" or something like that and selects SOLVER. I believe this is because SOLVER is saved in different directories for the different versions. If he does this and then saves, I can no longer open it on my (Excel 2003) computer without going through the same process.

I'm looking for a way to have code, upon opening the workbook, check if any of these missing references have been added, deselect them, and then select the correct reference (or something). Any ideas/help?