How to encrypt the password on EXCEL BOX?

[juma]

Hi

Thanks all of you who assist me for my problem.


With regards to the Password, how should we encrypt the password on th
input box on EXCLEL, so no one can see our password?
Currently when I gave the password on message box on Excel, it is no
in encrypted form.
What piece of code I add in the following routine in order t
encrypt/hide the password on runtime on EXCEL?

Regards

Jumma



Sub password ()

Dim Pword
Pword = InputBox("Type in your password")


If Pword <> "Proda"
Then
MsgBox "Sorry, incorrect password"
End
Exit Sub
Else
My code……
End if
End su

 

[Jan Karel Pieterse]

Hi Juma,

With regards to the Password, how should we encrypt the password on the
input box on EXCLEL, so no one can see our password?
Currently when I gave the password on message box on Excel, it is not
in encrypted form.
What piece of code I add in the following routine in order to
encrypt/hide the password on runtime on EXCEL?

You will have to use a userform for that with a textbox. In the
properties of a textbox there is one called "PasswordChar", a character
entered there is the character that will show once one starts entering a
password.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com