disable cell

J

JoeMNY

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
 
F

Frank Kabel

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)
 
P

Peo Sjoblom

You can try data>validation>allow>custom and use

=A3<>"X"

that will prevent anyone typing anything in A4 (but not pasting)
if A3 holds "X"


Regards,

Peo Sjoblom
 
J

JoeMNY

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?
 
Top