View Single Post
  #1   Report Post  
aken
 
Posts: n/a
Default locking cells based on results at runtime

hi,

how a cell or a range of cells be locked based on another cells value? let
me explain

if cell(A1)'s value is less then 30 then cell(b2) or cells b2:b10 must
be locked. user must not be able to do anything then on these cells. othewise
it must be open for editing.

aken