I have created a login page which includes levels of access. It is fairly simple as it checks what has been entered in the first text box (t1) and the second text box (t2), then checks with the accounts list to see firstly if that account exists then to see if it has level 1 access or level 2. Level 1 access takes the user to the "Owner" page whereas level 2 access takes the user to the "Employee" page. When i press enter it displays a message box saying "Why?" which i placed at the end of my code so i would be able to see if all of my code was being for some reason skipped. I am unable to figure out what i am doing wrong and i feel i may have gone about this the wrong way and there is probably a simpler way of creating a login which works off of a sheet and uses access levels. Here is my code and workbook.

Login Sheet Proto.xlsm

Please Login or Register  to view this content.