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