如果再配上以下代码时钟就活了:
Private Sub Workbook_Open()
[a1] = WorksheetFunction.Text(Now(), "hh:mm:ss")
Application.OnTime Now() + TimeValue("00:00:01"), "显示时间"
End Sub
Sub 显示时间()
[a1] = WorksheetFunction.Text(Now(), "hh:mm:ss")
Application.OnTime Now() + TimeValue("00:00:01"), "显示时间"
End Sub