Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lock cells
Can I lock a condition alone in a cell so that the cell still can be modified
Example in A1 I have a drop down list (select A, B ,C) n B1 I have IF(A1="A","Ape",IF*(A1="B", "Banana",if(C1="",""))) How do I protect C1 from being deleted when users fill in the form? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lock cells
One guess hazarded .. perhaps you're asking this ? You can have cells
containing formulas locked against accidental erasure / overwriting. If say, only col C contains formulas that's to be protected, then try this sequence. Select the entire sheet, click Format Cells Protection tab Uncheck "Locked" OK. Then select only col C, click Format Cells Protection tab Check "Locked" OK. Then apply sheet protection via clicking Tools Protection Protect Sheet Password? OK. That's it. Test it out. Only col C would be protected. Elsewhere on the sheet, cells would be unprotected, allowing for say, data inputs. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "novice" wrote: Can I lock a condition alone in a cell so that the cell still can be modified Example in A1 I have a drop down list (select A, B ,C) n B1 I have IF(A1="A","Ape",IF*(A1="B", "Banana",if(C1="",""))) How do I protect C1 from being deleted when users fill in the form? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lock cells
One guess hazarded .. perhaps you're asking this ? You can have cells
containing formulas locked against accidental erasure / overwriting. If say, only col C contains formulas that's to be protected, then try this sequence. Select the entire sheet, click Format Cells Protection tab Uncheck "Locked" OK. Then select only col C, click Format Cells Protection tab Check "Locked" OK. Then apply sheet protection via clicking Tools Protection Protect Sheet Password? OK. That's it. Test it out. Only col C would be protected. Elsewhere on the sheet, cells would be unprotected, allowing for say, data inputs. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "novice" wrote in message ... Can I lock a condition alone in a cell so that the cell still can be modified Example in A1 I have a drop down list (select A, B ,C) n B1 I have IF(A1="A","Ape",IF*(A1="B", "Banana",if(C1="",""))) How do I protect C1 from being deleted when users fill in the form? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lock cells
Thank you - it worked!
"Max" wrote: One guess hazarded .. perhaps you're asking this ? You can have cells containing formulas locked against accidental erasure / overwriting. If say, only col C contains formulas that's to be protected, then try this sequence. Select the entire sheet, click Format Cells Protection tab Uncheck "Locked" OK. Then select only col C, click Format Cells Protection tab Check "Locked" OK. Then apply sheet protection via clicking Tools Protection Protect Sheet Password? OK. That's it. Test it out. Only col C would be protected. Elsewhere on the sheet, cells would be unprotected, allowing for say, data inputs. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "novice" wrote: Can I lock a condition alone in a cell so that the cell still can be modified Example in A1 I have a drop down list (select A, B ,C) n B1 I have IF(A1="A","Ape",IF*(A1="B", "Banana",if(C1="",""))) How do I protect C1 from being deleted when users fill in the form? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lock cells
Glad that turned out fine for you !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "novice" wrote: Thank you - it worked! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Lock date in multiple cells | Excel Worksheet Functions | |||
Preserving lock on cells even when copied and pasted within a sheet | Excel Discussion (Misc queries) | |||
how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
Lock all cells? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions |