Cell lock help

Is there a way to lock a specific set of cells and not the whole work sheet?
I have several cells that have formulas in them that I do not want changed,
but other cells I need the user to add their daily info.

Any help is appreciated.
Steve

Select the whole sheet, do format>cells>protection, uncheck locked,
select the formulas in question (hold down ctrl while selecting them or
press F5 and click special, select formulas and press enter). Do
format>cells>protection and check locked. Protect the sheet.


Regards,

Peo Sjoblom

"S.C" wrote:

> Is there a way to lock a specific set of cells and not the whole work sheet?
> I have several cells that have formulas in them that I do not want changed,
> but other cells I need the user to add their daily info.
>
> Any help is appreciated.
> Steve
>
>
>

Steve

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet.


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 16:57:28 -0500, "S.C" <[email protected]> wrote:

>Is there a way to lock a specific set of cells and not the whole work sheet?
>I have several cells that have formulas in them that I do not want changed,
>but other cells I need the user to add their daily info.
>
>Any help is appreciated.
>Steve
>