Hi Excel Forum!

So I've got a pretty big worksheet that outputs to multiple pivots. Recently we've been having problems with one of the users of the workbook (3 people use it) modifying cells they shouldn't be.

I've been trying to figure out a VBA script that will do the following:

Row 1 will be an empty with the exception of cell B1 which will include the editors initials.
Row 2 will be empty
Row 3 will be the data headers.
Row 4 will start the data.

In Worksheet1, if the value of column A does not equal the initials entered in B1, then lock those rows from being updated. If the value in Column A does equal B1, allow editing of the cells within that row.

One feature I'd like to maintain is to keep filters on, so anyone can sort the data and read, but only edit rows that are not protected.

I don't even need a password, because its intent is to be a reminder 'you're in the wrong row' than a security device.

Your help is appreciated in advance!

Thanks,
Jonathan