View Single Post
  #1   Report Post  
tee
 
Posts: n/a
Default protection and inserting rows

I have protected a cell on a worksheet. When I try to copy or delete that
row on the worksheet, it won't allow because one of the cells is protected
and when I try to insert this row, it says, 'the cell is protected and
therefore 'read-only', the sheet must be unprotected'.

I did set it up so the users could insert and delete rows, but I want them
to be able to delete the entire row if needed, or copy a row to the next line
- but still not be able to change the existing protected cell.

Thanks