Password protect cells

[Punky]

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?

[Nick Hodge]

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?

[Dave Peterson]

You can lock cells or unlock cells (format|cells|protection tab).

After you lock/unlock cells, you can protect the worksheet
(tools|protection|protect sheet)

When the worksheet is protected, the user won't be able to changed the locked
cells, but will be able to change the values in the unlocked cells.

There are other things that are disabled when the sheet is protected (you'll
want to test to see if you need any of these features).

But be aware that worksheet protection is easily broken--but it will make it
somewhat safer for the lives of your formulas.

Punky wrote:
>
> 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?

--

Dave Peterson

[Punky]

Thank you very much. That was the angle I was missing.
Will the users still be able to save the sheet though?


Dave Peterson wrote:

> You can lock cells or unlock cells (format|cells|protection tab).
>
> After you lock/unlock cells, you can protect the worksheet
> (tools|protection|protect sheet)
>
> When the worksheet is protected, the user won't be able to changed the locked
> cells, but will be able to change the values in the unlocked cells.
>
> There are other things that are disabled when the sheet is protected (you'll
> want to test to see if you need any of these features).
>
> But be aware that worksheet protection is easily broken--but it will make it
> somewhat safer for the lives of your formulas.
>
> Punky wrote:
>
>>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?
>
>

[Punky]

Thank you!


Nick Hodge wrote:

> 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
>

[Dave Peterson]

They'll still be able to save the workbook.

Punky wrote:
>
> Thank you very much. That was the angle I was missing.
> Will the users still be able to save the sheet though?
>
> Dave Peterson wrote:
>
> > You can lock cells or unlock cells (format|cells|protection tab).
> >
> > After you lock/unlock cells, you can protect the worksheet
> > (tools|protection|protect sheet)
> >
> > When the worksheet is protected, the user won't be able to changed the locked
> > cells, but will be able to change the values in the unlocked cells.
> >
> > There are other things that are disabled when the sheet is protected (you'll
> > want to test to see if you need any of these features).
> >
> > But be aware that worksheet protection is easily broken--but it will make it
> > somewhat safer for the lives of your formulas.
> >
> > Punky wrote:
> >
> >>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?
> >
> >

--

Dave Peterson