Modify VBA to Current Sheet (not all sheets)

[g1terra]

Hello,

can someone help me modify this code to old protect the current sheet? I need the ability to set a new password like the current version below. Thank you so much in advance!

Please Login or Register  to view this content.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[g1terra]

This worked perfectly! Sorry for my lack of knowledge I'm trying to now make it unlock as well. So this one just to unlock the current sheet

Please Login or Register  to view this content.

[g1terra]

I figured it out, here is the code

Please Login or Register  to view this content.

[g1terra]

Thanks again!!

[YasserKhalil]

You're welcome. Glad it worked for you