Run macro every 1st or end of month

[smalltime]

I want to run macro every first and end of month, it is possible?

A cell in my worksheet has date in it.

TIA

[JeanRage]

Hi,

Yes, it is possible with an event macro ...such as
Private Sub Workbook_Open()
to be stored in ThisWorkbook

HTH

[smalltime]

how is the code?

[SarahPintal]

Maybe something like

Sub EventChange()
With Sheets("Sheet1")
If .Range("A1").Value = 1  Then

XYZ <--- this is where you put the macro data.. or call the sub

End If
End Sub