Run a Macro just after i open a workbook EXCEL

[mkparasar]

Hi Guys,

i want to trigger a macro just after i open my workbook in EXCEL with
the condition that if value of cell B1 is equal to todays date trigger
the macro and written the below code.

Private Sub Workbook_Open()
MsgBox Date
If Worksheets("Sheet1").Range("B1").Value = Date Then
My_Macro
End If
End Sub

But it does not seems to be work.

Any advice or help will be appriciated.

Thanks

KAKA

 

[Dave Peterson]

What's in B1?

If you have date and time, you'll have to ignore the time:

If int(Worksheets("Sheet1").Range("B1").Value) = Date Then

Did you put the procedure in the ThisWorkbook module?

Did you allow macros to run?

Were events enabled when you opened the workbook?