Altering read/write facility of individual cells

N

Nick Read

I would like to make a cell unwritable (i.e. a user
cannot input any data into it) until spefic line of text
is entered into the cell above it, is this possible in
Excek, and is fo how.

Many Thanks

Nick
 
G

Gordon

Nick said:
I would like to make a cell unwritable (i.e. a user
cannot input any data into it) until spefic line of text
is entered into the cell above it, is this possible in
Excek, and is fo how.

Many Thanks

Nick
Click to expand...
Not natively AFAIK - you'll have to write a VB script I would think.....

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
L

Lady Layla

Data Validation may work




: I would like to make a cell unwritable (i.e. a user
: cannot input any data into it) until spefic line of text
: is entered into the cell above it, is this possible in
: Excek, and is fo how.
:
: Many Thanks
:
: Nick
 
J

Jason Morin

Building off of Lady Layla's suggestion, assume we're
working with A1 and A2.

1. Click on A2.
2. Go to Data > Validation.
3. Under "Allow", click "Custom". In the box below put:
=$A$1<>""
4. Click on the "Error Alert" tab and put in an Error
message such as "Sorry, you must enter a value in A1
first."

Validation is a nice feature but can be easy overridden
by devious users. For example, you can copy and paste
over the Validation cell and erase the set-up. To learn
more about Validation in general, check out:

http://www.contextures.com/xlDataVal01.html

HTH
Jason
Atlanta, GA
 
G

Gordon

Jason said:
Building off of Lady Layla's suggestion, assume we're
working with A1 and A2.

1. Click on A2.
2. Go to Data > Validation.
3. Under "Allow", click "Custom". In the box below put:
=$A$1<>""
4. Click on the "Error Alert" tab and put in an Error
message such as "Sorry, you must enter a value in A1
first."

Validation is a nice feature but can be easy overridden
by devious users. For example, you can copy and paste
over the Validation cell and erase the set-up. To learn
more about Validation in general, check out:

http://www.contextures.com/xlDataVal01.html

HTH
Jason
Atlanta, GA
Click to expand...

I think the OP means that they want the cell to be locked until the text
is input - data validation won't LOCK a cell, will it?

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
D

Dave Peterson

It won't lock the cell, but it'll stop any entry that's typed into the cell when
the cell above is still empty.

And that may be enough for the OP.
 
Top