MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Username/password form

Posted by John Graumann on October 11, 2001 8:13 AM

I wish to create a mechanism where a user logs into a workbook, and gets different data depending on his/her username. Is there a way to create usernames/passwords in Excel in a secure manner, without storing them plain text on a hidden sheet ? Are there add-in controls for this ? Recommendations ?

ie: user opens workboook and is prompted for a unique username and password. Otherwise, workbook either wont open, or defaults to lowest access level.


Posted by Juan Pablo on October 12, 2001 1:18 PM

I don't know any other thing to do than creating a user form with the textboxes, and in a very hidden sheet (Protect your project as well) put the lists with the "permissions".

Juan Pablo