Hello Modine:

Ensure that all the other cells are protected. (select all the cells on the
sheet and then format cells protection locked should be slected).

You need set the cells where the users can add data as unprotected. (Do the
same above but for individual cells).

Then you need to protect the sheet.

I think that is what you want.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"Modine" wrote:

Hi,

I need to be able to protect my formulas in a column. I know how to protect
the columns I don't want edited. However in the column which I allow data to
be input, if someones enters a number in the wrong cell in a row then hits
delete it also deletes the formula in the cell so that when they go across
the row and come down to the next row the cell has lost its formula. Can
someone please help with this