|By default, all cells in an Excel sheet are locked. However, being locked means nothing until the sheet is protected.|
Once you protect the sheet, all cells are then locked and protected.
Allowing users to select locked cells is not the same thing as allowing them to change them.
If you want to allow users to change specific cells in a protected sheet, you need to unlock those cells and then protect the sheet.
Once you do that, the "unlocked" cells will not be protected.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.