Hi, and thanks for the help before on this topic.
Using "OnTime" in my personal.xls worksheet to run a different macro at a specific time works great - but it only works one time - the first time that specified time occurs after opening Excel.
If I leave Excel open overnight during the next night, "OnTime" doesn't run - apparently because it already ran 24 hours previously and Excel wasn't 're-opened' in the interim.
Is there a way to make OnTime run every night without closing Excel and re-opening it at least once every 24 hour period? As it works now, the update doesn't occur over the weekend (not in the office to close and re-open Excel) or on weeknights where I forget to close and re-open it.