Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cells
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cells
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 "SIRSTEVE" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cells
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cells
Thanks Miike. Your information work. Thanks again.
"Mike H" wrote: 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 "SIRSTEVE" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking cells | Excel Worksheet Functions | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking Cells | Excel Discussion (Misc queries) | |||
Locking certain cells | Excel Discussion (Misc queries) | |||
Help on locking cells | Excel Discussion (Misc queries) |