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

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

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

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

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