Warning Alerts Depending On Time Remaining To Finish Task

[peter renton]

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

[peter renton]

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

[peter renton]

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?