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

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

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

Thanks

In article
wrote:
Is it possible to lock/unlock cells based on another cell value?

If cell = "text1" unlock cells A4:B4 and lock cells C4:D4 If cell =
"text2" unlock cells C4:D4 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