Conditional Row Protection

[davefio]

I have a sheet with 100's of rows of entered data that I want to
protect as the user marks the row as accepted. Does anyone know how I
can achieve this.

What I envision is the user moving down the sheet entering data, he/she
could mark the far left column with an x to protect that row or the
other cells to the right of that row.

I am trying to protect the user from inadvertently erasing data from
prior transaction entries.

Thanks

 

[JRF]

Sorry for not writing this for you but you could easily use the changed
event of the worksheet to set the protection on the row if the value of
the designated cell had an X.

Or you could use the selection change even and prevent the user from
selecting the cell if the x were present.