Run Macro Upon Opening

B

Bill Mosserati

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!
 
T

Tom Ogilvy

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
 
Top