M
Mark
I have a worksheet where a user enters a two values in two
cells. The user then uses the solver to establish the
value of two other cells. I would like to protect all the
other cells, that the user does not enter data into, so
their contents is hidden when I protect the sheet. When I
protect the sheet, the solver does not function. Is it
possible to apply some levels of protection which will
enable the solver to operate, or is the solver and the
sheet protection cababilities incompatible?
cells. The user then uses the solver to establish the
value of two other cells. I would like to protect all the
other cells, that the user does not enter data into, so
their contents is hidden when I protect the sheet. When I
protect the sheet, the solver does not function. Is it
possible to apply some levels of protection which will
enable the solver to operate, or is the solver and the
sheet protection cababilities incompatible?