Hi,

Paste in this module

Private Sub Workbook_Open()
Application.OnTime TimeValue("15:00:00"), "MyMacro"
End Sub

Change MyMacro to the name of your code and include the 2 lines below at the
start of your code. Of couse this only works if the workbook is open


Application.OnTime
TimeValue ("15:00:00"), "MyMacro" ' change to your subs name

Mike
"Heera" wrote:

Hi,

I have a workbook and i want to write a code which should run on a
specific time(3.00 PM) everyday at and complete a task.

Regards

Heera