View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Cell Entry That Locks Selected Cells From Any Data Entry.

Say the list is 7 columns wide. If I put "A" in B2, I want to be able to
input data in C2 thru G2. But, if I put "B" or "P" in B2, I want cells C2, E2
and F2 to allow no data to be entered. If the B2 entry is changed to "A", all
cells C2 thru G2 become available for entry again.