06-25-2010, 02:35 PM
What is the best way with Excel/VBA to save a list of passwords? Right Now I am using workbook1 to input the info into a userform, which then creates or opens a password book on the desktop (which requires password to open) and also checks the username of the person logged in to that of the person who saved the password book on workbook open.
It still fills somewhat unsecure, because you know with excel a password can be hacked to open, and then if anyone know VBA could hack past the workbook_open event. Im wondering if someone has a more secure idea for this.
06-25-2010, 03:51 PM
If you legitimately must store passwords, you should encrypt them first. If the encryption is based on a master password seed that only you know (and have to enter each time a password(s) is viewed), then someone reading your code and/or encrypted passwords will not easily be able to recover the original passwords. Of course you will need to memorize or store the master password elsewhere (and ideally be able to change the master password periodically). Search the net for password encryption (or perhaps two-way/reversible hash). Let me know if you get stuck on this. The work I have done is one-way hashing for password validity checking (making it nearly impossible to recover the password from the encrypted value).
06-30-2010, 02:28 AM
In my company, we all have network logon IDs that are unique to each user.
When I need my Excel programs to be secure and passworded, I use the Environ function.
This allows you to just store a list of all of the user's Window's logon IDs in your workbook and then you can verify a user against this list.
So, in essence, only someone with an ID in your list can logon. This way, your application is as strong as the windows ID.
07-01-2010, 12:38 AM
Ive already got that on there. I was just thinkin of the possiblity of some kind of encryption that is used by wireless networks, banks, etc that someone with basic level of VBA knowledge or an excel pw recovery tool cant override