dplumlee12
New Member
- Joined
- Nov 13, 2012
- Messages
- 15
So I have a computer that runs production spreadsheets continually. Excel always open. Different spreadsheets continually but personal.xlsm stays open all the time.
We have a production schedule we need to adhere to and it requires an action every so many hours. The number of hours between actions can change.
What I am looking for is a alarm clock that tells the operator to do an action 20 minutes before the action is late.
So I need to start the timer from the scheduled time and not the time the application was opened. I also would like the number of hours between alerts to address a cell range.
I would also like the alert to be audio as well as msg box.
Anybody have any idea?
We have a production schedule we need to adhere to and it requires an action every so many hours. The number of hours between actions can change.
What I am looking for is a alarm clock that tells the operator to do an action 20 minutes before the action is late.
So I need to start the timer from the scheduled time and not the time the application was opened. I also would like the number of hours between alerts to address a cell range.
I would also like the alert to be audio as well as msg box.
Anybody have any idea?