Hello

I'm trying to write some codes which will automatically prompt the use to
enter a password before they can use the workbook.
In addition, a feature that allow user to change the password.

However, I'm wondering if there is any function provided by VBA for Excel
that can allow me to encrypt the password
or i cannot safely put the password into worksheet coz the user can easily
disable the "Macro Fucntion" of Excel...

Another way is to keep the password in code and then protect the code for
viewing, but by what way can I change the password placed in codes...?

I'm just a newbie of programming, and i don't wanna try to access other
external database...
so by simply using Excel, how can i fufill the password protect function?

Many thx for all u greatful guys! :)

William