Two issues you need to know.

1: Using Window's Scheduling and the Workbook_Open event means Excel must be closed in order to work.

2 Using VBA's OnTime Method means Excel must be open at that time in order to work.


You can use Scheduling to open a different workbook that checks to see if the Login book is open, If not then opens it, and Calls the Login procedure in the Login Book.

Use Scheduling to insure the login book is open and use OnTime to run the login procedure. Opening an open workbook should not cause any problems, but test.

Write a Workbook_BeforeClose Sub to remind you to leave the book open on those days so OnTime can work.