Lock cell if based on value of corresponding cell

[kashyap]

Hi, I was tring to lock cell if value of corresponding cell is error
If value B3:B20 is error lock corresponding cells in ColumnE, F & H


OR

unlock cell if value of corresponding cell is >0

If value B3:B20 is >0 unlock corresponding cells in ColumnE, F & H

 

[shemayisroel]

I think this may help you?

http://www.mrexcel.com/archive/VBA/19248.html