how can i get a macro to run on a given day?
P papou Sep 15, 2004 #2 Hello Place a test in the Workbook_Open event: Private Sub Workbook_Open() If Date = "15/09/2004" Then Macro1 End Sub And in a standard module place your macro : Sub Macro1() MsgBox "It's time to run" End Sub HTH Cordially Pascal
Hello Place a test in the Workbook_Open event: Private Sub Workbook_Open() If Date = "15/09/2004" Then Macro1 End Sub And in a standard module place your macro : Sub Macro1() MsgBox "It's time to run" End Sub HTH Cordially Pascal
