raiken20
11-19-2015, 07:50 AM
I am trying to create a log in log out form using excel vba.
1. If I hide the DATA sheet, and I enter the employee ID which is available. its giving me employee not available.
2. If I arrange the position of the sheets (put tracker first then data), its giving me error message.
3. I also want to that each time the employee click submit, it will ask for a password. if the password is correct, it will then do time stamp for log out or log in.
4. Also, In the tracker sheet. I put a column for the total number of hours. (I want this automatic if log in and log out time is filled in).
Please help me.
1. If I hide the DATA sheet, and I enter the employee ID which is available. its giving me employee not available.
2. If I arrange the position of the sheets (put tracker first then data), its giving me error message.
3. I also want to that each time the employee click submit, it will ask for a password. if the password is correct, it will then do time stamp for log out or log in.
4. Also, In the tracker sheet. I put a column for the total number of hours. (I want this automatic if log in and log out time is filled in).
Please help me.