Cell lock help

[S.C]

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

 

[Peo Sjoblom]

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

 

[Gord Dibben]

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