Excel VBA Code for locking/unlocking a cell based on the value of another cell

I have a spreadsheet that check box in cells A1 through A250. I would like to "gray out/lock out" cells B and C of the line depending if the check box value of "A" is True or False . For example:

If the value of A10 = "True" then B10 and C10 would be unlocked.

If the value of A10 = "False" then B10 and C10 would be locked.

Does this make sense?

Thanks for your help!!

Jim

Hi xladept,
I am interest in this too. I copy these codes to sheet 1 VBa, it does not work.
I am very appreicatee if you can place in excel file.

Thanks

Hi xladept,
I will post a seperate new thread with a sample.

Thanks