Making table expandable after protection

[APVR]

How to make a table expandable after the worksheet is protected. I have a table with formulaes I want the formulaes to be protected so that the users don't delete them but I want the table expandable to add data in the table.

 

[DauntingGecko]

Just put protection on the cells you want to protect (i.e. the ones with formula's).

 

[APVR]

Just put protection on the cells you want to protect (i.e. the ones with formula's).

I have locked the cells with formulaes already so that they can not be changed. The problem is that I have a table in the worksheet, when you press tab on the key board the table range expands, like a data base and the formulae above are copied to relate to the new line of the table. When you protect the sheet this function is not available, which is very limiting as tables are great for end users but if you can't protect the formalues without making the table expandable then they are useless for the end users, because as you know end users love deleting formulaes.