If you are writing VBA code to use Solver, simply set a reference to it
once in your project (manually, like you are doing now) and you are done.

If you mean that you need to check to see if Solver is installed on another
user's machine before you attempt to make calls to the Solver routines,
then include this line of code somewhere at the top of your code:

AddIns("Solver Add-in").Installed = True

--
Regards,
Bill Renaud


"robs3131" wrote in message
...
Hi,

Is there a way to have code check the "Solver" box VBA? FYI - I
currently
need to do this manually using the following steps:

- Go to "Tools - Macros - Visual Basic Editor"
- Go to "Tools - References"
- Check the checkbox next to 'Solver' and click 'OK'

Thanks!


--
Robert