Dynamic ranges (tables) not working on a protected sheet

[Excel_vba]

I have a data set that is defined as a table (Ctrl + T). There are formulas so I locked those cells and Protected the sheet. If I am at the bottom right cell, and press Tab to add a new row, I get an error message: "Cannot use this table functionality on a protected sheet"

I really need to protect the cells with formulas so that the are not accidentally deleted. But I also want to retain the Table format.

Is there a way around this without using VBA?

[aydeegee]

Hi Excel_vba

I am not aware of any way without VBA.

Just for interest, what do you have against VBA?

Regards
Alastair