|Just protected or password protected?|
What will your process be if the user makes a mistake and enters an incorrect value in S10?
What will your process be if the user makes a mistake and enters a value in the wrong Sx?
What will your process be if the user enters a value in S10 before entering values in the other cells in that row?
While it's fairly easy to meet your stated requirements, things often go terribly wrong once users start to get involved. When all users behave, locking the rows once Sx is filled is fine, but how are you going to deal with the issues that arise when users misbehave?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.