About this tutorial:
Video duration: 15:32
We can capture the user-name, login and logout times and then calculate the number of hours worked automatically using Excel VBA.
We need 3 files:
1. The file in which we wish to work
2. Log-details file
3. User-name and password file against which we can confirm the correct user-name and password entry of the person logging in.
When we open our workbook a login form is presented. After confirming our credentials we can start working. In the process our user-name and login time is recorded. We ensure that the user cannot close the workbook without logging in. This is done by disabling the…