Schedule Tasks ..

Im having trouble with getting a macro to run at a specific time and day (Every Thursday at 7PM).

Here's what I have done so far..

1. I added my excel file to the task scheduler
2. created a class module and place the code below into it.

In testing the workbook opened but it asked if i wanted to enable or disable the macros - how do I get around this? And it does seem to kick off the macro (create_all).

Private Sub Workbook_Open()
If Hour(Now) = 1130 And Weekday(Now, vbMonday) < 7 Then
' TheNameOfYourCurrentProcedureHere
create_all
If Workbooks.Count = 1 Then
Me.Save
Application.Quit
Else
Me.Close True 'save the changes and close the workbook
End If
End If
End Sub