When you apply protection, there are separate options that control inserting rows and deleting rows. If this is not sufficient, you will need to provide more detail.
How to Protect a TABLE
I have a user that wants a spreadsheet designed with some specific requirements. There is a Named TABLE on a sheet. (There is other data in this sheet not in the table.) The user needs to allow the user to ENTER data into the table (add Rows) but needs to make sure that no one can DELETE the table itself.
I assume that a table is an "object" and you could apply Protection settings to a table object just like you could a sheet object. Not sure this is the case?
In any event, is there a method to meet the user's requirements?
2 answers
Sort by: Most helpful
-
-
Emi Zhang-MSFT 25,551 Reputation points Microsoft Vendor
2024-06-26T09:06:28.92+00:00 Hi,
It seems you need VBA to help you:
https://stackoverflow.com/questions/46642257/protect-excel-sheet-but-allow-table-to-be-modified