Limit data entry in a series of cells if one cell has data entered.

I have 3 cells. If I enter data in any one of the cells, I want the other two cells to be locked out (IE, no data can be entered).

How can I do this?

What are the three cells?

B14, c14, d14

First make sure that the three cells are unlocked. Then protect the worksheet. The copy and paste the macro below into the worksheet code module.

Please Login or Register  to view this content.

Sweet! Thanks a ton!

Oops. I'm actually trying to help a co-worker and he just told me that it will need to apply to only certain worksheets and also will need to apply to rows 14 - 44

Can you just give me the general format for that and I can amend it as needed? Thanks again!

You will have to loop through the appropriate worksheets and activate them one at a time. Then on each worksheet you will have to loop through rows 14 to 44 assigning a variable to the row number in the target address. You will also need to change the Intersect range to B14:D44. It may be a little tricky.