have it run everytime you open it, and in the very top of the macro check
what day of the week it is. If it isn't the correct day, then have it Exit
Sub

--
Regards,
Tom Ogilvy

"Bill Mosserati" wrote in message
...
Hey Gurus of programming,

Is there any way to set an event or macro to run when a
workbook is first opened every monday? I am sure you can
program something to run when you open it, but can you
specify a particular day of the week?

Thanks all!