Hiding formulas in a Worksheet without password

K

kanti44

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
 
D

Dave Peterson

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.
 
K

kanti44

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
 
D

Dave Peterson

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.
 
K

kanti44

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
 
K

kanti44

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

kanti44 said:
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
Click to expand...
 
D

Dave Peterson

I don't understand.
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
Click to expand...
 
K

kanti44

I do get an error message when I change one of the selections (from one of
the dropdown lists). The erreor says: "The cell you are trying to change is
protected and therefore read only"; which I believe is a reference to the
formulas cells.
In the below setup, the formula cells results are based on the selections,
the date, and the subject.
I want will be using the workbook and I don't them changing the formulas.
 
D

Dave Peterson

I don't think it's the cells with the formulas.

How did you make the dropdowns?

If you used data|validation, then unlock the cell itself.

If you used a combobox from the control toolbox toolbar, then unlock the
linkedcell.

If you used a dropdown from the forms toolbar, then unlock the cell used in the
cell link.
I do get an error message when I change one of the selections (from one of
the dropdown lists). The erreor says: "The cell you are trying to change is
protected and therefore read only"; which I believe is a reference to the
formulas cells.
In the below setup, the formula cells results are based on the selections,
the date, and the subject.
I want will be using the workbook and I don't them changing the formulas.
Click to expand...
 
K

kanti44

Thanks a bunch, Dave!
Unlocking the dropdown cells did the trick (I used data|validation).
Very grateful
Kanti44
 
Top