conditional macros

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Help needed 0
Starting macro 3
conditional formatting -dissapears 3
DataMacro problem after Splitting Access Database 2010 0
Macro to create daily worksheets 6
vba powerpoint pasting named shape in selected named slides 0
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top