Excel Login Form that records date and time of login

I do not normally reply to posts that do not have a sample workbook. However this is a function that other programmers might want to use.

Irt depends on very hidden sheets and a VB project locked for viewing. These are good enough to keep the casual hackers out. They are not true security. The VB project password is Password.

The attached workbook has four sheets: Admin, Password, Login Log and Sheet 1. The first three sheets are normally very hidden.

The Admin sheet has two buttons: one to show the very hidden sheets and another to hide the very hidden sheets. If you are seeing this sheet, the other sheets should also be visible, so the button there is as a backup in case you navigate to this sheet other than by logging in.

The Password Sheet has a table of user names and passwords. The Admin password is Admin.

The Login Log Sheet has a list of people and when they logged in.

When the file is opened, the first thing the program does is hide the sheets that should be hidden. Then it launches a form to get the user name using a drop down list populated by the Password Table. Then they enter the password and click the Login button. If the passwords match then the file remains open. If the password entered doesn't match the one in the table, the file is closed - try again.

If the user name is Admin (hard coded in the code), then the hidden sheets are revealed. Other passwords are managed through the table.

Hello @fastcar. My solution is very simple for the average user and very intuitive. Login for Administrator - Admin, password - Admin. The login for a regular User is User, the password is 123. The Admin Sheet is hidden for a regular User. I think you will figure out how to use it yourself. Good luck!

I can't think of a way to bring the form up separate from the Excel Sheet. The best I know how to do is bring it up on a blank sheet. I could make this a fancy flash screen, possibly with navigation buttons.