Thread: Locking Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SIRSTEVE SIRSTEVE is offline
external usenet poster
 
Posts: 13
Default Locking Cells

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

"Cimjet" wrote:

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" wrote in message
...
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.