Run Macro Once a Week

[Littlemalky]

Does anyone know how I can run a macro every Monday?

I currently have a macro for this report I'm doing; however, there is a new piece to it in which I need to copy and paste a total from one sheet to another, but only on Mondays.

I run this macro everyday, but this portion of it only needs to be done when I run it on Mondays. How do I do this? I have Excel 2007.

 

[John_w]

If Weekday(Date) = vbMonday Then
.....

 

[Littlemalky]

Thanks John!

 

[RSXchin]

You may want to add this at the beginning fo the code so it doesn't run EVERY time you open the book on a monday.

    If MsgBox("Do you want to run the macro now?", vbYesNo) = vbNo Then Exit Sub