hi,

how can a cell be locked via VB scriprting in excel. to say, Cell A1 must be
locked if cell B1's value is less then (or any other conditions), say 35.
also, depending upon some condition, can the whole range of cells say
renge(A1:A40) also be locked???

as such the only way what am doing is: select the cell - format - cells -
protection tab - check-mark locked. this is manual setting, can this work be
done programatically??? that is what am on to.

i have tried by going to all the things like VB's programming codes that i
can go but just cant get the result.

any help will be truely appreciated.

taken