Last line shoiuld read: the numbers in formulas do change with above
selection not "Formulas do change ...."

"kanti44" wrote:

The dropdowns were unolcked. However, because the formulas cells are
protected, they can only be read (according to the error message). Below is
the setup:
Selection 1
Selection2
Selection3

Date1 Date2 Date3
SubjetcA Formulas Formulas Formulas
SubjectB Formulas Formulas Formulas
SubjectC Formulas Formulas Formulas

Cells with formulas do change with above selections.
Kanti44


"Dave Peterson" wrote:

Unlock the cells that are used with the dropdowns.

You don't have to lock all the cells on a worksheet. You don't have to unlock
all the cells, either.

kanti44 wrote:

Dave, Thanks!
This does not work because the cells with the formulas are supposed to
change when a user makes some selections from drop down lists.
Kanti44

"Dave Peterson" wrote:

You can select the cells with the formulas that should be hidden
Format|cells|protection tab|click locked and hidden

Then protect the worksheet (tools|Protection|protect sheet). But don't supply a
password.



kanti44 wrote:

Greetings
How can I hide and protect formulas in a worksheet that I want to share with
other users but don't want to have to use a password?
Thanks a bunch!
Kant44

--

Dave Peterson


--

Dave Peterson