How to check Solver and Forms 2.0 Object Library permanently?

Y

yoyo2000

Oops!
I happen to find that

SOLVER
Microsoft Forms 2.0 Object Library

in VBA References in Excel can't be checked permanently,that's once I
check them in a new blank excel file,and then close that blank file(of
course I don't save it) and open another new excel file,those two
component are back in the unchecked state.

but this weird phenomenon doesn't occuered for others,I don't know how
to solve it...
 
J

Jon Peltier

These items are referenced on a per-workbook basis, not globally for the
Excel application.

The Forms 2.0 Library automatically checks itself as soon as you add a form
to the VBA project.

I'm not sure you want the Solver checked automatically, because it could
cause problems if you send the file to someone without Solver installed, or
worse, with an older version installed.

But if you do really want these items automatically checked, open a new
workbook, reference the items, then save it as Book.xlt (an Excel template)
in the XLSTART folder. All workbooks you subsequently create will be based
on this workbook template.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top