protected worksheet

[Wylee]

I need to insert and delete rows in a protected worksheet. When I set the protection, I indicate the user can access unlocked cells, insert and delete rows. After I save the worksheet and try to add rows, it will let me but it will not let me delete rows althought the access box to that task haad been checked.

 

[JoeMo]

I need to insert and delete rows in a protected worksheet. When I set the protection, I indicate the user can access unlocked cells, insert and delete rows. After I save the worksheet and try to add rows, it will let me but it will not let me delete rows althought the access box to that task haad been checked.

Even though you have checked the Delete Rows box, you can only delete a row while the sheet is protected if all the cells in the row are unlocked.