Un-protect and protect multiple sheets

Hello! Excel Forum is the best place for help when I get stuck. Thank you for any replies!

I was able to get help creating some code to copy a row to another sheet and then deleting that row. I didn't want the data to be compromised in anyway so I am protecting the sheet. I added in code to un-protect (as the sheet will be protected) and then some actions and then protect the sheet again. The problem I am running into is the second sheet I am copying to is protected and for some reason I can't get the code to un-protect the second sheet. Help!

Please Login or Register  to view this content.

Please Login or Register  to view this content.