Conditional Protection of Cells
 

I have a worksheet that acts as a departmetnal log. Users can input
information in a number of columns but when the request is approved (columns
8 & 9) are filled in by designated officials, we want the rest of the row to
become protected against subsequent changes.

We have password protected the cells in columns 8 & 9 so only the designated
officials can input. But once they have, we need the rest of the unprotected
cells in that row to become unchangeable without a password.

We were thinking of if/then statements in each user cell to check for
entries in the same row in column 8 & 9 before allowing/preventing input into
the cells, but do not know how to code it.

Would a macro that checks the values of those cells under columns 8 & 9 and
protecting/unprotecing the user input cells depending on those values be more
appropriate?

Any help is appreciated.

Thanks
Jack