View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Protecting cell formulas in excel 2007

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