Lock and protect selected excel rows with VBA code

Originally Posted by HaHoBe

Any entry into Column B would have to leave Column C and D open for more entries in that row or how will you fill the entries in these columns when the row is locked?

Agreed! But the user will lock the Row only when he finishes filling all the 4 Columns on that particular row wont he? Atlease that's what I think.

Best if the OP states if he requires something otherwise.

Hi, NeedForExcel,

the yellow highlighted area holds Columns B to D (which is 3 Columns) and the rows 2 to 11. With your code (which could be started at any time even if not entry or change was made) the whole area between B2 and F and the last entry row in Column B is blocked. I can´t agree on that from what I read that from post #10.

Ciao,
Holger