You need to unset the "locked" attribute for the relevant cells, under
Format Cells/ Protection, before you protect the worksheet. By default the
locked attribute is set for all cells.
See
http://office.microsoft.com/en-gb/he...968401033.aspx and
http://office.microsoft.com/en-gb/he...785801033.aspx
--
David Biddulph
"Al Taylor" wrote in message
...
Hi folks,
I have a pretty simple spreadsheet in excel 2007 and I need to protect
some
of the formulas from being deleted or edited. I can protect the whole
sheet
but then users cannot enter data in ANY cell. What am I doing wrong? I
just
want to protect the cells with formuls in them.
Al