Quote Originally Posted by Bieke1111 View Post
Apparently these cells can get locked when people are copy/paste data from another workbook to these cells.
I have tried this and cannot reproduce it. Steps:

  1. Format a cell to be unlocked
  2. Protect the sheet
  3. Copy a locked cell from another workbook
  4. Paste to the unlocked cell on the protected sheet
  5. The unlocked cell value is updated, and the cell remains locked

However, if the sheet is not protected, then copying a locked cell and pasting to an unlocked cell will cause the target cell to become locked.

Can you provide more detail about how these unlocked cells are getting locked?