Run Macro on open of Excel2000 spreadsheet 2

[hsummer]

I want a form to load or macro to run when a certain workbook is opened - like autorun. I open it from Excel (not from another VBA app).

How do I do it?

Thanks,
Harold

 

[Loomah]

Put this in the code pane for ThisWorkbook, sit back and enjoy!

Option Explicit

Private Sub Workbook_Open()
UserForm1.Show
End Sub