Share via

How to Protect a TABLE

Dom 836 Reputation points
2024-06-19T18:04:02.86+00:00

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?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,959 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Barry Schwarz 3,071 Reputation points
    2024-06-19T23:35:09.47+00:00

    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.

  2. Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
    2024-06-26T09:06:28.92+00:00
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.