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.
Printable View
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.
in the code window:
dblclick the ThisWorkbook
select Workbook
Private Sub Workbook_Open()
End Sub
Or you could create an
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....Code:Sub Auto_Open
'Place Code In Here
End Sub