How to run macro on particular time

hardik_228 · Post by **hardik_228** » Wed Aug 12, 2009 9:50 am

Hi there

Thanks to all of you to help me last time.

I am trying to run my macro at 11'o clock in the morning everyday.

But I could not figure out.

I tried if statement, but not work.

Any suggestion.

Thanks in advance.

Post by **Marcus Tettmar** » Wed Aug 12, 2009 10:25 am

Here's what to do:

1. Open Macro Scheduler
2. Double click on the macro to open it up in the editor
3. Click on the "Run When" tab
4. Check off each day on which you want it to run.
5. Enter 11:00 in the time box
6. Save and close the macro.