Hiding formulas in a Worksheet without password
 

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

Hiding formulas in a Worksheet without password
 

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

Hiding formulas in a Worksheet without password
 

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

Hiding formulas in a Worksheet without password
 

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

Hiding formulas in a Worksheet without password
 

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

Hiding formulas in a Worksheet without password
 

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

Hiding formulas in a Worksheet without password
 

I don't understand.

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


--

Dave Peterson

Hiding formulas in a Worksheet without password
 

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.

"Dave Peterson" wrote:

I don't understand.

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:
Selection1
Selection2
Selection3

Date1 Date2 Date3
SubjectA 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


--

Dave Peterson

Hiding formulas in a Worksheet without password
 

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.

kanti44 wrote:

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.

"Dave Peterson" wrote:

I don't understand.

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:
Selection1
Selection2
Selection3

Date1 Date2 Date3
SubjectA 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


--

Dave Peterson


--

Dave Peterson

Hiding formulas in a Worksheet without password
 

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

"Dave Peterson" wrote:

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.

kanti44 wrote:

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.
Others will be using the workbook and I don't them changing the formulas.

"Dave Peterson" wrote:

I don't understand.

kanti44 wrote:

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

Date1 Date2 Date3
SubjectA 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


--

Dave Peterson


--

Dave Peterson