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.