Hi Lonpuz

You can use the workbook open event in the thisworkbook module
http://www.rondebruin.nl/code.htm

Private Sub Workbook_Open()
If Day(Date) = 1 Then

' Your code

End If
End Sub

If you not open the file on the first day it will not run the code
If you open the file two times on day 1 then it will run two times so you must build in a few checks

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lonpuz" wrote in message ...
At the beginning of each month, I need to copy/paste value over a number of
formulas so the results become fixed. I know how to automate the process
using the recorder, but want it to do it automtically when the 1st of the
month comes. I'm sure I can do that by making reference to a today()
formula, but don't know how to write the code. My apoligies if this was
already posted somewhere, as I couldn't find the exact info I was looking for.

Regards,

Lonpuz