Issues with Code to Add New Table Row to a Protected Sheet

[Kogen]

I found some code on youtube to add a new row to a protected table via Form Controls Button, but it only adds a new table row if the sheet is unprotected. When it's protected it selects the cell directly underneath the table where new data is usually added but it's protected. I would greatly appreciate any input as to why this isn't working. Thank you all for taking the time to read this, here is the code:

Please Login or Register  to view this content.

[CK76]

Well... you need to set pswStr = "" to your actual password. Otherwise, it's using blank as password to unlock the sheet.

And if that's not the password... it fails to unprotect.

[6StringJazzer]

Thanks, see post #2 for response.

[Kogen]

So, I set all passwords to "0" and it's still not working. I've attached a test file if taking a look will help. Originally, I had set the password to "" because this is going to distributed to others within my organization. I just wanted to remove the ability of messing up the formulas. Is there a work around to not require a password?

OJT Tracker Test.xlsm

[CK76]

You have typo in your code.

Please Login or Register  to view this content.

It should be .Unprotect.

FYI - Unless you know exactly what is going on in the code, don't use "On Error Resume Next". It ignores errors and pretends nothing has happened.

[Kogen]

CK76,

Thank you so much for your help! I made the suggested corrections and changed the password to "". Everything works just as it should now.