I'm setting up a workbook for continual shared use. Several of the other
users, rather than just deleting the data, highlight the row in question and
delete the row. That's throwing off all of the formulas on the final sheet.

Is there a way to set protection that will allow the users to edit their
data as they need to, but maintain the format and design of each of the
sheets, disallowing them from removing any rows?

Thanks
~Dani