Trying to use VB to protect and Unprotect a worksheet

[jfoerch]

Hi All,
How do I protect a specific worksheet (not necessarily the "active sheet") with VB. That particular sheet, I initially protected it using "password" the password. Then I'm trying to unprotect the sheet when the userform is initialized. Then when it's terminated, I want to re-protect it. Here is the code I'm trying to use...

To Unprotect

Please Login or Register  to view this content.

To Protect (haven't really tested this one, just assuming it's wrong because the other doesn't work.

Please Login or Register  to view this content.

Can someone help me figure out the correct code? Thanks!

[Mumps1]

Try:

Please Login or Register  to view this content.

[jfoerch]

That worked. Thanks!

[Mumps1]

My pleasure.