conditional locking

I have already asked a similar question but I am still not getting the results I had hope for. My goal is to have for instance an entire worksheet that is locked so that other users cannot change anything. However, there will be an exception of cells like C6, C12, C18, etc.. In these particular...

Hi all, I have a range of empty cells in columns A,B & C. If a value is entered in any of the cells A1, B1 or C1 i want to lock the other two cells to prevent data entry. This will then be the same for rows 1 through to 4 as shown in the table below.. <tbody> A B C 1 5 locked locked...

I need help with a macro so that simply typing in an X in a cell will password protect the entire spreadsheet. My boss wants me to have our purchase orders lockup once he puts in the PO information and puts his digital signature, he wants to type in an X in a cell and have the entire thing...