VBA Store Password

[Kallassy]

Hello.

I am done with a financial model and the end user will start using it.
To access the file, I have an input box where he can enter his credentials (username and password) which are preset by myself. Is there a way to have a "Change Password" button where he can change the password and this password will be stored for future use and override the previous password?

 

[mole999]

you might create an excel very hidden sheet and push the password there. The file would have to store anyway either in plain text in code or out of sight. Security on excel can be broken usually, so it would be only so secure