Use this idea within a workbook_open event in the ThisWorkbook module

If Day(Date) = 3 Then sheets("sheet3").PrintOut 'preview

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Philsp" wrote in message
...
How can I automatically print a worksheet on same day each month