Share via

running clock problem in excel

Anonymous
2024-09-24T11:37:44+00:00

I have inserted a running clock in a w/sheet1 using 2 line code in Sub running_clock() in w/book module, saved as macro enabled file. But its not running whenever I open the w/book, runs only when run the macro.

Is there any process to run it automatically whenever I open the w/sheet1.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2024-09-24T20:39:20+00:00

In the Visual Basic Editor, double-click ThisWorkbook in the Project Explorer pane.

Copy the following code into ThisWorkbook:

Private Sub Workbook_Open()
    Call running_clock
End Sub

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest