View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E Charlotte E is offline
external usenet poster
 
Posts: 59
Default Max number of runs in a time period?

How can I make sure, that af macro is only executed 50 times during the last
hour?

I.E.
If I call the macro for the 51. time, and it has only been 45 minutes since
I called the macro for the first time, the macro will pause for 15 minutes
before continue, ensuring that I always only run the macro max 50 times
during an hour.

And, if I then call the macro for the 52. time, and it has only been 20
minutes since I called the macro for the 2. time, the macro will now pause
for 40 minutes.


How to make sure that a macro in only called/execute max 50 times during the
last 60 minutes?


TIA,