lower or upper case password

[chubbychub]

I have the below code, it works fine, but if someone can help me change it to use upper case letters or lower case letter for password please, here is the code

Please Login or Register  to view this content.

[:) Sixthsense :)]

Just replace this line in both the places.

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[chubbychub]

It worked for the first sub, but for the second sub, I got the debugger pop up highlighting the below line:

Please Login or Register  to view this content.

[bakerman2]

How about this ?

Please Login or Register  to view this content.

[:) Sixthsense :)]

ThisWorkbook.Unprotect LCase(pwd)
ThisWorkbook.Sheets("Inventory").Unprotect LCase(pwd)[/CODE]

Should be Ucase() I think

[chubbychub]

THAT WORKED! thank you bakerman2 and Sixthsense both of you. Rep added and thread will be marked solved.
Bakerman2 could you explain why I need to add the 'LCase' , why was it necessary to add that in my macro?

[chubbychub]

i tried it "UCase()" it don't work, but it worked with "LCase", thank you both !!

[davsth]

The original password playtoy2 is lowercase hence it needs to be lower case when presented

Please Login or Register  to view this content.

could be replaced with

Please Login or Register  to view this content.

[bakerman2]

Thanks for rep+. Much appreciated.

davsth has given you the short version, I'll present the long one.

When using this

Please Login or Register  to view this content.

you can enter the password in uppercase or lowercase in the userform. They will both be converted to uppercase (temporarily) when performing the check.
But pwd will hold exactly what you've entered in the userform.
Suppose you have set the sheet password in lowercase and pwd is uppercase in userform there's a difference so we convert the userform value to lowercase to match sheet password.