I have a workbook that opens with one visible worksheet, "Login" while the others remain hidden. In cell H22 I have a drop down listing usernames from range DA24:DA29. In cell H24 I am requesting users to enter a password. Can someone help me write some VBA code to assign different passwords for each username and then unhide specified worksheets depending on the username? I would like to display a msgbox saying something like, "the password is incorrect" if the password given does not match the appropriate username.
Let's suppose...
DA24 = Eric (password should be genius)
DA25 = Cameron (password should be mechanic)
DA26 = Larissa (password should be firefly)
DA27 = Lucy (password should be valentine)
DA28 = Sarah (password should be ricky)
DA29 = Bob (password should be rainbow)
If Eric logs in, all sheets should be unhidden. For everyone else, only sheets named "Table", "Change", and "Total" should be unhidden.
Thank you so much!
Let's suppose...
DA24 = Eric (password should be genius)
DA25 = Cameron (password should be mechanic)
DA26 = Larissa (password should be firefly)
DA27 = Lucy (password should be valentine)
DA28 = Sarah (password should be ricky)
DA29 = Bob (password should be rainbow)
If Eric logs in, all sheets should be unhidden. For everyone else, only sheets named "Table", "Change", and "Total" should be unhidden.
Thank you so much!