Hello,

I'm trying to insert a row by hitting tab on the last column of a table. With the workbook unprotected this works perfect (moves my formulas down, copies my data validation list, etc.) but when I protect the worksheet to ensure certain cells are not cleared and also to hide my formulas, it seems to disable the ability to add a new row to the table. Is this something that i will need a macro to accomplish or is there a better way?

Any help is much appreciated.

Thank you,

- Justair