Except for the warning at 1 hour, the rest of it is exactly what I intended too. Did you call the macro that uses the OnTime method?
Except for the warning at 1 hour, the rest of it is exactly what I intended too. Did you call the macro that uses the OnTime method?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi
Sorry still cant seem to get it to work? i have tried calling the macro etc, could you drop it into
the test sheet for me to see what i am doing wrong ??
Peter
hI
I have added the coding
The warning comes up at 30 mins to go but re occurs every minute, how do i get it to do one warning at 60min to go then one reminder at 30mins to go and an over due warning when it goes minus? also could it pick up the customer name in the warning so its easy to see which row the alert is for?
Selecting the completed seem to stop the alert but not the clock (do i need to put a code in w column?) also code it restart the clock if this is de selected.
Sorry if i am been a bit thick here but i am just trying to get my head around how the codeing works
Thank you for looking
Peter
Hi
I have manged to sort the picking up of customer name etc in the warning.
If someone has time to look at the other items that would be good
Peter
Also how do i get it to work on all rows in the sheet?
Last edited by peter renton; 06-18-2013 at 08:36 PM. Reason: added query
Posting Permissions
Reply With Quote
Bookmarks