Conditional Proctection?

[Iriemon]

Is it possible to lock/unlock cells based on another cell value?

If cell = "text1" unlock cells A4:B4 and lock cells C44 If cell = "text2"
unlock cells C44 and lock cells A4:B4

The text1, text2 are from a combo box drop down list located on another
worksheet

Thanks

 

[Richard]

Is it possible to lock/unlock cells based on another cell value?

If cell = "text1" unlock cells A4:B4 and lock cells C44 If cell =
"text2" unlock cells C44 and lock cells A4:B4

The text1, text2 are from a combo box drop down list located on
another worksheet

Thanks

Unless I'm missing something, since you're already using a combo box
why not add code to lock/unlock the relevant cells, into the combo box
change/click event?

HTH

­­ 
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo