Locking cells

[chipgreenfield]

THis might be a pretty simple question. But how do you lock a formul
in a cell without protecting sheet? I am having trouble with this.
change the cell format and the sheet to protected but this just lock
everything. ANy help would be great.

Chi

 

[Harald Staff]

Hi Chip

You can't. What you must do before protecting the sheet is to unlock the
ranges where entries are allowed.

--
HTH. Best wishes Harald
Followup to newsgroup only please

THis might be a pretty simple question. But how do you lock a formula
in a cell without protecting sheet? I am having trouble with this. I
change the cell format and the sheet to protected but this just locks
everything. ANy help would be great.

Chip

creating financial statements

 

[chipgreenfield]

Thanks Harald. ANother quick question about locked cells.

How do you keep cells within filtered data locked without locking th
actual filter? I have the cells I want locked but this also locks th
filter even though the filter is formatted as unlocked. Thanks agai
in advance.

Chi

 

[Andrew]

Thanks Harald. ANother quick question about locked cells.

How do you keep cells within filtered data locked without locking the
actual filter? I have the cells I want locked but this also locks the
filter even though the filter is formatted as unlocked. Thanks again
in advance.

Chip

If I understand your question correctly, Question 3 on the following page
answers your question.
http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010565541033&CTT=98

 

[R. Todd Miller]

Chip,
Don't know if this helps but you can 'kinda lock' a cell without
protecting the sheet by using Data-Validation-Custom and put two
double quotes "" in the formula box. The user can't type-over your
formula BUT they could delete it.