Private Sub Workbook_Open()
If Time TimeValue("12:10:00 PM") And _
Time < TimeValue("12:30:00 PM") Then Call Main
End Sub

--
Regards,
Tom Ogilvy

"Lost and Looking for Help" wrote:

I want this statement to run upon opening my excel file. I have this code
located in the This workbook tab and i want it to call the Sub Main in the
Worksheet info if it is inbetween this time. I know this code isn't right
but can and how can you do this.

Private Sub Workbook_Open()
If Time "12:10:00" And Time < "12:30:00" Then Call Main
End Sub