System Time auto running in VBA Excel

[Dave_LearningExcel]

Hello,

May I request your help? I need a system time running in my excel and I use below code:
Private Sub workbook_Open()
Dim Hr As Boolean

Hr = Not (Hr)
Do While Hr = True
DoEvents
Range("E11") = TimeValue(Now)
Loop

End Sub

Would you please advise how to make this code auto running when I open my excel file?

Much appreciate your help. Thank you.

Best,
Dave

 

[PureBluff]

You need to place the code within the ThisWorkbook section of the desired project within VBE.

However, this macro will never stop, so you won't be able to use the workbook while it's running, which is indefinitely.