can I lock just the formular in a cell

[Max]

Re: can I lock just the formular in a cell

One interp from your subject line ..

Assume there's a formula in C1,
and we want to protect just this cell in the whole sheet

Try this sequence ..

Select entire sheet
Format > Cells > Protection tab > Uncheck "Locked" > OK
("unlocks" the entire sheet)

Select cell C1
Format > Cells > Protection tab > Check "Locked" > OK
("locks" only cell C1)

Then apply sheet protection via:
Tools > Protection > Protect Sheet > Passwrd? > OK

Test it out. All cells on the sheet, other than cell C1,
will be unlocked / unprotected.

 

[pcconfused]

I'm trying to just stop someone from changing the formular in a cell but
allow data to be changed

 

[Max]

I'm trying to just stop someone from
changing the formula in a cell but
allow data to be changed

But isn't that what I've suggested in the response ?
Did you try it out ? Which steps in the suggestion
did you encounter problems doing ?
Let me know so that I could explain better.

With the formula cell C1 locked and sheet protection applied, you'll find
that you can "touch" (ie input, delete, do whatever action) any cell in the
sheet other than the formula cell C1. If you were to select C1 and try to
say, delete the formula in C1, you'd hit an Excel error msg that its
protected, etc ....

Try the steps again, and post back here.

If it works ok, and instead of a single formula cell C1, you have other
formulas as well in C2:C10, just repeat the steps but select C1:C10 instead
of just C1, before you click Format > Cells > Protection tab > Check
"Locked" > OK, and apply sheet protection. You don't have to do it one cell
at a time <g>.

 

[pcconfused]

I think you'r saying I can't lock the formular AND still change data in that
same cell-ok

 

[Gord Dibben]

confused

A cell can contain a formula which returns a value.

If you overwrite that formula by manually entering another value in
that cell, the formula is gone.

There is no way to have both at the same time.


Gord Dibben MS Excel MVP

I think you'r saying I can't lock the formular AND still change data in that
same cell-ok

 

[Max]

Thanks for the assist, Gord !
Guess I was really misled by the OP's subject line <g>

 

[Gord Dibben]

The subject line was misleading.

After OP had rejected your "protection" steps it became more clear
what OP wanted to do.


Gord

 

[Max]

The subject line was misleading.

After OP had rejected your "protection" steps it became more clear
what OP wanted to do.

Admittedly, I also failed to grasp the subtleness behind the OP's 1st reply,
though I must have read it through a couple of times. Cheers.