On Friday, December 13, 2019 at 6:30:27 PM UTC-6, GS wrote:
I use Solver with Excel 2007. After starting Excel, Solver will not work.
Both boxes for Solver Addins (yes, there are 2) are checked. The only
solution I have found is to uncheck both boxes, close the addins list,
opening it again and check both boxes. After closing, Solver works fine.

I have tried to write VBA scripts to automate this but none have worked.
Only the manual procedure indicated will do the trick.

Any help appreciated.

Have you tried Repairing your Office?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Hi Garry. I have figured out how to do Repair. Unfortuntely it did not
help. Any other ideas? Your help is greatly appreciated.

Addins are registered in either the HKey_Current_User or the HKey_Local_Machine
Registry locations. Solver Add-in is not listed in either but is listed (only
once) in each installed version of Excel Add-ins Manager dialog. Checking it
causes Excel to install this addin on 1st use, but it does not show in the
Registry where other Add-ins or COMAddins show. Once installed, it's available
to all installed versions of Excel, for all users. That suggests it registers
under HKey_Current_Root; - good luck finding where!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion