VBa to unlock rows as data gets filled in?

[tonywatsonhelp]

Hi Everyone,

I have a data input form in Column B to J starting at row 12

the page is protected and I want to unlock the protected rows as data gets added to the row above.
it would be best to trigger it from column B

So it would go:

on selection if cell is in column B the unlock the row below it ColoumnsB:J

so if you can imagine the whole sheet is protected, except the row I want them to write in or any rows already wrote in?

Any ideas


Tony