Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Excel VBA Timer Event – Run Macro at Specific Time – Automatic Schedule
Learn to schedule excel macro to run at specific time. Run macro automatically at certain time & date. Adding Timer in Excel to repeatedly execute a Excel VBA Macro. It is a sophisticated method to add remainders in Excel.