Auto Start VB In Excel (Simple)

[ricer]

I need to have some VB in an Excel workbook to initialize as soon as the workbook is opened. I have searched the Excel VB Archive and cannot locate the correct syntax for this.

This should be a very simple issue.

[Static]

in the code window:

dblclick the ThisWorkbook

select Workbook

Private Sub Workbook_Open()

End Sub

[DJDANNYK]

Or you could create an

Sub Auto_Open
  'Place Code In Here
End Sub

This will do exactly the same thing as geoff_xrx posted, but if you are creating personal macros that are located in the xlstart folder, they will initialise as soon as Excel is opened....