what you could do is, add a timer and enter a big interval
in it, so that it only runs at ur specified time in the
24hrs. inside that timer event you can place the command
to open the macro, this way everytime at the specified
interval it will keep running the macro.
NOTE: you will have to leave the form open in order to
make the timer keep running.
