VB protect & unprotect worksheet with password

[Launchnet]

Need someone's help

I'm trying to unlock a worksheet that has been protected with a password. I used xyz as my password example

So far I have used the following 3, but none of these will work

Please Login or Register  to view this content.

sure could use some help. I used this many years ago, but I've forgot how to do it.

[broro183]

hi,

You're close!

Just a slight tweak to your syntax should do it, try either of the following for unprotecting a specific worksheet:

Please Login or Register  to view this content.

hth
Rob

[Launchnet]

Many thanks. It's been a good number of years since I used this and VB Help wasn't any help.

[broro183]

thanks for the feedback - I'm pleased I could help

Rob