Password prompt for acessing a workbook

[«Â¤Æ¡­]

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

 

[Cole]

From what I understand, it can be done but using password facility of Excels
which can be put in when you save it
File -> Save (Save as) -> Tools -> General Options -> Password to open,
Password to modify

or

Menu bar -> Tools -> Protection
see which on is fit