Punky

Protection is a two part process (by default ALL cells are locked, so
applying protection to the sheet will lock them ALL). Select the cells you
wish UN-protected and go to Format>Cells...>Protection and un-check locked,
then protect the sheet via Tools>Protection>Protect Sheet... These cells
will now be changeable, with the others locked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Punky" <veenes@postmaster.co.uk> wrote in message
news:OLkADGuRGHA.5908@TK2MSFTNGP14.phx.gbl...
>I have a sheet that people need to enter data into, but I have a problem
>with people deleting the formulas in other cells.
> Does anyone know if there is a way to password protect one or several
> cells without protecting the entire sheet?