MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Run a Macro Automatically When the Workbook Opens


May 19, 2002 - by Juan Pablo Gonzalez

Jeremy asks:

How do I get a macro to run automatically when the user opens a workbook?

Jeremy Kim

Place something like this in the Workbook module

Private Sub Workbook_Open()
	Call MyMacro
End Sub

Where “MyMacro” is the name of YOUR macro.