Home |
Search |
Today's Posts |
#1
|
|||
|
|||
disable cell
Greetings,
I'm sure this is possible but I can't figure it out. How can I disable a cell based on input in another cell. Example: A1=Powered A2=Glider A3= A4= If an "X" is placed in A3, I want A4 disabled (locked). TIA |
#2
|
|||
|
|||
Hi
not completely save but - select cell A4 - goto 'Data - Validation -. custom - enter the formula =A3<"X" Note: This does not prevent copying data to this cell. If you need more security you have to use VBA (an event procedure) -- Regards Frank Kabel Frankfurt, Germany JoeMNY wrote: Greetings, I'm sure this is possible but I can't figure it out. How can I disable a cell based on input in another cell. Example: A1=Powered A2=Glider A3= A4= If an "X" is placed in A3, I want A4 disabled (locked). TIA |
#3
|
|||
|
|||
You can try datavalidationallowcustom and use
=A3<"X" that will prevent anyone typing anything in A4 (but not pasting) if A3 holds "X" Regards, Peo Sjoblom "JoeMNY" wrote: Greetings, I'm sure this is possible but I can't figure it out. How can I disable a cell based on input in another cell. Example: A1=Powered A2=Glider A3= A4= If an "X" is placed in A3, I want A4 disabled (locked). TIA |
#4
|
|||
|
|||
I am just learning VB, can you help me with the code?
"Frank Kabel" wrote: Hi not completely save but - select cell A4 - goto 'Data - Validation -. custom - enter the formula =A3<"X" Note: This does not prevent copying data to this cell. If you need more security you have to use VBA (an event procedure) -- Regards Frank Kabel Frankfurt, Germany JoeMNY wrote: Greetings, I'm sure this is possible but I can't figure it out. How can I disable a cell based on input in another cell. Example: A1=Powered A2=Glider A3= A4= If an "X" is placed in A3, I want A4 disabled (locked). TIA |
#5
|
|||
|
|||
Thanks that works but what I would really like is to lock the cell to not
allow any entry. I am just learning VB. Is there a way to do this with a VB Procedure? "Peo Sjoblom" wrote: You can try datavalidationallowcustom and use =A3<"X" that will prevent anyone typing anything in A4 (but not pasting) if A3 holds "X" Regards, Peo Sjoblom "JoeMNY" wrote: Greetings, I'm sure this is possible but I can't figure it out. How can I disable a cell based on input in another cell. Example: A1=Powered A2=Glider A3= A4= If an "X" is placed in A3, I want A4 disabled (locked). TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |