Macros and timer

[Erantes]

Hi I'm trying to set macros off at certain times on different worksheets. what seems to be happening is when my macro is activated on sheet 1 it activates macros on other sheets as well. What also seems to happen is if I'm on another worksheet at time of activation on sheet 1 it doesn't activate. My aim is to have 11 macros going off at set times on 10 different sheets without them interfering with each other.

 

[Micron]

You should be able to write another sub that calls any number of subs. How depends on where the subs are that you want to call. If there are 9 on one sheet you can call them from another procedure on the same sheet, like

Sub Call_All
RACE1TIME60
RACE2TIME60
RACE3TIME60
ETC.
End Sub

This assumes that the subs to be called don't take any parameters, which is the case in the posted code I read. All you'd need to do is run Call_All.

 

[Erantes]

Thank you Micron that has worked nicely.

 

[Micron]

Glad I could add to the solution.