Sorry for the long-winded thread title!
I've found that when using the Application.Ontime function in multiple spreadsheets that once triggered, the respective subs will be run in ONLY the active spreadsheet.
For example, I have two spreadsheets that operators use to capture data. I have Application.Ontime functions to trigger macros at specific times of the day for shift changes. The code simply locates the first blank column, inserts the text "Shift Changeover" at the top of the column, and unhides a row for reviewing the document. I've found though that the macros will ONLY fire in the active spreadsheet, and not the spreadsheet in the background - thus making the process redundant:
Example code in the spreadsheets:
The same code exists in both spreadsheets, but the cell reference for the "Shift Change" header, and the "Reviewed By" lines are different. As one spreadsheet evolved from the other, they had originally had the same sub names, but I have modified the spreadsheets to give them unique sub names, but still get the same result.
I cannot figure out how to set timed events using the Application.Ontime function so that subs will be triggered LOCALLY in the respective spreadsheets, and not just in the active spreadsheet.
Apologies for the wordy explaination, I hope it makes sense to someone and they can help me to figure this one out.
Thank you!
A
Bookmarks