Hello:

I am using below code to on each sheet when its activated/landed.

Private Sub Worksheet_Activate()

Application.DisplayFormulaBar = False

Call Test

End Sub
I need a code after Application.DisplayformulaBar = False as below:
If Time is between 8am to 10 am then carry on otherwise exit
Let me know if you have any questions.
Thanks.

R