Urgent support please: How to run Macros continously?

Dear All,

I have a VBA coded Excel file in which there are process deadlines dynamically matched with the current date/time, and if the related checkbox of the process is not clicked on-time by the user, file sends automatically a warning e-mail via Outlook to dedicated e-mail adress written in the code.

My problem is that the Macros in the workbook only works when the file is double-clicked and opened but do not work dynamically.

How can I make the Macros run continously when the file is constantly open and the values (deadline status) change by current time flowing?

Simply, I want the file to be dynamically sending several e-mails and do not stop the loop for each time check boxes are forgotten to be clicked.

Please see the attachment.

Thank you in advance for your prompt supports.

Best regards,