How to auto-run a macro

[Bryan123]

Hi All,

Good day!

How do I automatically let the macro run when the excel file is opened? Is it possible? I want the macro to start working when I open the file rather than use a button to run it.

Thank you

Bryan

 

[jmacleary]

Hello. You need to create a macro with a specific name, and store it in the ThisWorkbook section of the workbook code. As follows:

<code class="ocpCode">Private Sub Workbook_Open()

' Put your code here

End Sub</code>

 

[Bryan123]

Hi, thanks for the quick revert.. works perfectly! thanks