Locking formulas without password protecting worksheet

[DayStar]

Does anyone know how to lock a particular cell to prevent the changing
or erasing of a formula without having to password protect the entire
worksheet/workbook?

My field is showing as locked, but is not preventing the deletion or
change of the formula contained there in. We need to share this
workbook without having to password protect it.

Can anyone help?

 

[Paul B]

DayStar, you have to protect the sheet for this to work, you don't have to
put in a password but the sheet must be protected, another option might be
to warn the person when they select a cell with a formula, want keep them
from changing or deleting it but might work, you could put some code like
this in the worksheet code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.HasFormula Then
MsgBox ("Please do not remove or change"), , ("Formula In Cell")
Else
End If
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Pete_UK]

Another simple way is to use a different background colour for the
cells you do not want anyone to edit, eg bright yellow or green - just
tell your co-workers not to do anything with the coloured cell(s).

Hope this helps.

Pete