Altering read/write facility of individual cells
 

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

Nick Read wrote:
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
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!

Data Validation may work




"Nick Read" wrote in message
...
: 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

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



-----Original Message-----
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
.

Jason Morin wrote:
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




-----Original Message-----
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
.


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!

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.

Gordon wrote:

Jason Morin wrote:
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




-----Original Message-----
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
.


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!

--

Dave Peterson