I am using excel 2007.

I want to allow users to delete rows from a protected worksheet.

I understand that if there are any cells in the row that are locked then the user will not be able to delete the row. That is OK. In the rows that I want the user to be able to delete there do not need to be any locked cells.

But, no matter what I do I simply cannot find a way to delete any rows once the worksheet is protected.

Consider an extreme example - not particularly useful, but it demonstrates the point.

On a fresh worksheet select all possible cells and use "Format Cells ..." to mark them all as unlocked, then protect the worksheet specifying that all users are allowed to - select locked cells, select unlocked cells, insert rows and delete rows.

Now try to delete a row - you can't!

You can insert rows but you can't delete them.

The "Insert" menu shows "Insert Sheet Rows" and "Insert Sheet" as being available.

The "Delete" menu only has "Delete Sheet" - everything else is greyed out ...

Someone please tell me that I am being stupid and doing something wrong and that this isn't just another example of Excel being horribly broken