Automatically Log-off All and Stop a running loop in the middle

[SunOffice]

Aim/ Object - I've made this Time Calculation Tracker. I've made an extra commandbutton 'Log-off @ 17:00" to automatically log-off everyone @ 17:00 everyday (business days only or when I only work on this workbook).

Problem - How can I make the 'Log-off @ 17:00' commandbutton work automatically in the workbook, so every employee will be logged-off at the same time and easy to track their total log-in hours?

The codes I've made are working fine, but If the last employee is on leave and I click on the commandbutton 'Log-off @ 17:00", omg! it runs continuously ...till until the end of the columns. Could u plz help me out in this too?

One More Query - How to stop a running loop in the middle?

Kindly help me out!

Thanks in advance!

[Leith Ross]

Hello SunOffice,

Here is the safest way to log users off.
How To Force Users to Quit Programs and Log Off After a Period of Inactivity in Windows XP

I don't have Windows 7 or Vista and can't offer any advice on those platforms.

[SunOffice]

Thanks for ur reply, but sorry I didn't explain my problem clearly.

Actually I would like to make the commandbutton 'Log-off @ 17:00" work automatically in the attached workbook, so every employee's Log-off time will show automatically. I work on this workbook to track their total log-in hours, but many times I have to manually insert their fixed log-off time as 17:00. That's why I need any code for the commandbutton 'Log-off @ 17:00" to work automatically.

one more issue in this - The codes I've made are working fine, but If the last employee is on leave and I click on the commandbutton 'Log-off @ 17:00", it runs continuously ....till until the end of the columns. Could u plz help me out in this too?