Print upon opening document, but only at a certain time of day

[Dantrith]

Title says it all really. I have a workbook that upon opening I want to refresh, run a macro, then print. I'm pretty sure I can do all that but I want to limit the time so that unless someone happens to open it at 6:58 am it won't automatically print.
Thanks

 

[Dantrith]

Private Sub Workbook_Open()

ActiveWorkbook.RefreshAll
If Date = Sheets("Report").Range("B2") Then
'checks if date in B2 his todays date, if it is todays date then it skips down to samedate.
GoTo SameDate
End If
'changes the date to todays date so that if the file is opened later
'that day then it doesn't print pages automatically.
Sheets("Report").Range("B2") = Date

Call ColorAllColumns
Call printreport

ActiveWorkbook.Close


SameDate:

End Sub

This was the code that did it. It doesn't quite do it how I originally imagined but it doesn't automatically print 5 pages the next time the user opens the book which was the end goal.