Running A Macro Later or at a Specified Time

You can use the OnTime command to create macros that will run automatically at another time or a specified time. The value in parentheses defines the number of hours, minutes, and seconds before the macro should run. Follow these steps to create a macro that will run in Excel at a later time: