Share via

Private Sub Workbook_Open() not working

Anonymous
2023-06-29T13:42:19+00:00

I made my macros function name this and ended with End Sub but its not running. Any idea on why this isn't working?

Microsoft 365 and Office | Excel | For business | 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 No comments

Answer accepted by question author

HansV 462.6K Reputation points
2023-06-29T15:16:21+00:00

Did you create it in the ThisWorkbook module? That is the only place where Workbook_Open will be run automatically.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2023-06-29T16:02:44+00:00

    That was it. Thanks so much!

    Was this answer helpful?

    0 comments No comments