Running Solver through a Macro

[Gilt Lorn]

I created a healthcare cost comparison calculator for work. To run the Solver, I recorded a macro, then assigned the macro to a red button. I fixed the initial glitches on my machine (really just checking the Solver box in the VBA Project references list), and it works fine on mine.

But, when I send it to any co-worker, the same error message comes up every time.

"Cannot run the macro 'iso9000.xla!HCSolve'. The macro may not be available in this workbook or all macros may be disabled."

I've checked the same errors in others' as in mine. Doesn't fix it. Also, I am making sure they're opening a macro-enabled workbook.

Any ideas?

 

[Eric W]

Do they have the Solver Add-in enabled?

File > Options > Add-ins > Manage > Excel Add-ins > Go > check the Solver box > OK