View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
john tempest[_2_] john tempest[_2_] is offline
external usenet poster
 
Posts: 27
Default lock/unlock cells

say i have 2 cells B20 and B21. when i enter a number in B20 i want B21 to
lock, i also want this to work via versa so if i enter a number in B21 i want
B20 to lock. this is so a number cannot be put in both cells
is this possible
thankyou john tempest