Thread: lock cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoeMNY JoeMNY is offline
external usenet poster
 
Posts: 6
Default lock cells

Greetings,

As a newbee to VBA I could use some help he

I have a small spread sheet that uses A1:G5 the cells in question are
Columns D-G

D1=Powered
E1=Glider
F1=Corporate
G1=Member Owned

D2, E2, F2, G2 should allow for an "X" only in the cell.
An "X" in D1 should Lock E2 and vice-versa
An "X" in F2 should Lock G2 and vice-versa

TIA
Joe