Locking Cells

[SIRSTEVE]

I have a spreadsheet that I created and everything is just the way I want it,
but I want to be able to lock the date field so that it can not be change by
other people.

Can anyone give me some advice on how to do this? I tried the locking cell
feature in format/cell/protection. And that works fine. But when I go to
tools/protection/protect sheet, it locks the entire spreadsheet. I just want
to lock the date cell only, and everything else can be live.

 

[Mike H]

Hi,

Selct all of your cells by clicking the box abive row 1 then
format|cells|Protection and remove the locked checkmark
select your date cell and repeat the above but this time put the checkmark
back in the locked box for that cell
Protect the sheet and your done

Mike

 

[Cimjet]

Hi SIRSTEVE
I don't know your layout but if you highlight everything that you don't want
to lock and right click on your mouse select Format cell, go to Protection
and remove lock cell then go back and protect sheet, you will have what you
want.
Regards
Cimjet

 

[SIRSTEVE]

Thanks Miike. Your information work. Thanks again.

 

[SIRSTEVE]

Thanks Cimjet, your information was very helpful. I now have fixed the
problem. Thanks a million for your input.