While it seems odd I would say it is not a bug. Would it be any more correct
to allow you to delete locked and protected cells? How about deleting a
header row or a row with grand totals in it? It seems that there is no right
answer to that question. To me the key is understanding the limitations and
working around them.
--
HTH...

Jim Thomlinson


"Perico" wrote:

Excel 2003: I have a column where cells are locked on a protected sheet and
protection is turned on. In turning on protection, Excel offers checkbox
options, such as "Allow users to detlete rows." The problem is When the user
tries to delete a row they get a message that "cannot delete cells that are
locked." This is a catch 22, because to get the benefits of sheet
protection, you lock cells. And if you check "Allow users to detlete rows."
in creating the password, but you can't delete a row containing protected
cells, what good is that checkbox? Is this a bug?
Thank you.