this macro runs when i opn the workbook but the ontime function doesnt works (i do get msgbox 1)
i need this macro to call another macro ThirtyMins after 11.24 am (morning)
PS:both macros are in ThisWorkbook modulePrivate Sub Workbook_Open() msgbox 1 Application.OnTime TimeValue("11:24:00"), "'" & ThisWorkbook.Name & "'!ThirtyMins", False End Sub
thanx
piyush
Bookmarks