Hi Kash,

Did you activate the ontime event? Best is to put the application.ontime
statement in an event procedure of the workbook or worksheet.

Sub ontime()
Application.ontime EarliestTime:=Range("A10"), Procedu="Test"
End Sub

Sub test()
MsgBox Prompt:="hello"
End Sub

Wkr,

JP

"Kash" wrote in message
...
I'm able to get both the msg

msgbox("Cancel old on timer event") & msgbox("Setting New Timer") but
still
macro is not getting triggered.