You need a time and date to schedule a macro with OnTime; otherwise, it will run immediately, since you will have scheduled it to run some time on 1/0/1900.

One reason that Excel might be busy (and the macro not run) if it it gets left in edit mode -- e.g., you put the cursor in the formula bar and leave it there ...