Run vba macro automatically in certain time

Hello,

I have several excel sheets in the same excel doc, each sheet has it's own vba macro and they all has the same code, anyway i need them to automatically run every certain time, i have done my search for that topic but none of the simple code i found is working.

Could you please help me with that.

Thank you,
-----------------------------------------
vba code sample.
-----------------------------------------

Private Sub Worksheet_SelectionChange(ByVal CountrySize As Range)
If CountrySize.Address <> "$O$5" Then Exit Sub

Application.DisplayAlerts = False

Dim ws As Worksheet: Set ws = ThisWorkbook.Sheets(7)
Dim r, r2 As Range
.
.
.
.
.
.
.

Call otherMacro
End Sub

Private Sub otherMacro()
Application.DisplayAlerts = False

Dim ws As Worksheet: Set ws = ThisWorkbook.Sheets(7)
Dim r, r2 As Range
.
.
.
.
.
.
End Sub