Max number of runs in a time period?

C

Charlotte E

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I'm trying to do a "count" function at the end of a dynamic pivot table 0
Implement a progress bar when the macro run inside another workboo 2
Pause a macro by resetting current time 3
macro to continue running if error 6
Subtracting time...again 2
Time Range Summary - parse data 5
Make code aware of the workbook file name 4
Copying Solver results of each iteration to a given location in a workbook 1

Top