i have set up a macro using the Application OnTime function. I have used it
on several excel files and two of them work and two of them don't even though
the code is the same. Any ideas why this is happening?

I need the macro to run after it is opened, but not run on every opening, so
I have tried to schedule it to run at a certain time.

Private Sub Worksbooks_Open()

Application.OnTime TimeValue("6:45:00"), "Compliance"

End Sub

(In ThisWorkbook Code)