Daily tips for using Microsoft Excel.

Sunday, May 19, 2002

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.