Why does this not work with a password?
You can unprotect/reprotect using the password in the same way as with no
password.

Or unlock just the cells Solver needs to change.

Tim

--
Tim Williams
Palo Alto, CA


"Gilbert LAC" <Gilbert wrote in message
...
I've succesfully built a macro that run 2 solver commands in 2 separate
tabs
of the same workbook. However, If I protect the worksheets with
passwords,
the solver macros trigger an error message - error in parameters or
contraints. It works if I unprotect and then protect within the macro, but
cannot use it if I really want to put a password. Any alternatives?