Please HELP me!

  • Thread starter Thread starter mompmc
  • Start date Start date
M

mompmc

Greeting to all!

How can I lock a few cells (Area A), when I start to make entry o
other cells (Area B)?

What I mean is, I have make up 3 areas of cell, each area consist of
few cells. First, I will key in data to Area A, then Area B, at th
same time, Area A is lock to prevent any futher input.

Your help is very much appreciated.

Thank you!
mompm
 
Hi
one way: use data validation
if Area A is column A and area B is column B try the following
- select your cells in column A (lets assume you start in row 1)
- goto 'Data - Validation'
- enter the formula (unter the 'custom' category):
=B1=""

This allows an entry in A1 only if B1 is empty
 
Thanks!

I tried. but it work only when all the cells in "Area A" filled.
Is there any way that will make this function work when either 1 of th
cell in "Area B" filled.

Thanks!
mompm
 
Hi
try the following:
- select cells E3:H10 (your area A)
- goto data validation and enter the following formula
=COUNTA($E$14:$H$21)=0

as soon as you enter any value in E14:H21 (Area B) you can't enter
anything in area A
 
Hi Frank,

I noticed that I not able to edit / add any value at Area A, but I ca
delete it. Is there any way that I could totally LOCK the cells?

mompmc
Thanks again!
 
Hi
not withou using VBA and using the worksheet change event as well as
protecting this worksheet. Give me a note if you like an example for
this
 
Back
Top