Protect sheet except of ListObject

[Stevenn]

Can I protect a sheet without protecting an entire table? I will still have the option to insert, delete, and edit rows inside a table.

 

[Jon von der Heyden]

Hi

This is quite an irregular question yet it's the 2nd time I see it asked in a week.

Consequently to the first time it was asked (in one of the LinkedIn groups), I wrote an article on the solution.

Please note that you still have to unlock input columns.

Also, when protecting your sheet, take care to apply the correct settings, such as Format Rows and Delete Rows.