Insert row for table on protected worksheet

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

The "Inserting Rows" is selected but it still won't work. I did some research and it seems to be a common issue.

I put together the following code:

Please Login or Register  to view this content.

but i keep getting a debug error on the following line:

Please Login or Register  to view this content.

I'm stuck

This code works perfect and is placed in a module.

Please Login or Register  to view this content.

This code is then placed in the workbook as a private sub:

Please Login or Register  to view this content.