Is there a way that I can protect a worksheet but specify certain cell
ranges that a user could delete cell ranges in? Essentially what I
have are several "tables" of data and I'd like to protect everything
in the sheet except the data in the tables. I'd like the user to have
the ability to delete rows from the data in a specific table, i.e. the
user should be able to select the cells that make up part of the data
in the table and have the option to delete the selected cells and have
remaining cells shifted up. I've tried unlocking the cell ranges I
want to have this ability and checking the boxes next to "delete rows"
and "insert rows" when protecting the sheet, but so far am not getting
the functionality I'm looking for (delete is grayed out in the context
menu when I select cells in that range).