"pcconfused" wrote:
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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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


"Max" wrote:

"pcconfused" wrote:
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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

"pcconfused" wrote:
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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

"Max" wrote:

"pcconfused" wrote:
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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

On Tue, 10 Jan 2006 08:40:02 -0800, "pcconfused"
wrote:

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

"Max" wrote:

"pcconfused" wrote:
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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks for the assist, Gord !
Guess I was really misled by the OP's subject line <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

The subject line was misleading.

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


Gord

On Wed, 11 Jan 2006 03:43:34 +0800, "Max"
wrote:

Thanks for the assist, Gord !
Guess I was really misled by the OP's subject line <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895

The subject line was misleading.

... which was the sole lead given on the orig. post <g

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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--