Vba - table insert row - protected sheet

Hey All,

I have a code that will unlock a protected sheet and insert a new row into the table. (top row of selected range). Problem I am having is its not protecting the sheet with password when finishing up. It's fairly chopped up and I'm hoping someone can help refine this.......newbie here.

Please Login or Register  to view this content.

Have you tried stepping through the code line by line using F8 in the VBA Editor? That may tell you which lines are being skipped (or at least enable you to check values of variables involved at each step).

I stripped the overcompicated code down to this. IT work fine but inserts at the bottom of the table. Ideas of how I can get it to insert on the top row?

Please Login or Register  to view this content.

I'd think using "Range("A1").End(xlDown)" will find the last contiguous used row below cell A1.

If your table was always in A1:??, then wouldn't you just reference Range("A2")? (I'm guessing it's not that simplistic...)

A16 is the first row of the table, some reason it add only to the bottom......little stumped

Try this insert line instead:

Please Login or Register  to view this content.

Works perfect!