B Bob Phillips Aug 3, 2005 #2 The question doesn't make sense, VBA is there with Excel. If you want to run a macro when the workbook opens, name it Auto_Open.
The question doesn't make sense, VBA is there with Excel. If you want to run a macro when the workbook opens, name it Auto_Open.
? -_-\ Aug 3, 2005 #3 thank you~ But i am still confused in VBA and macro. I used the visual basic editor to create a form. and how can I open the form (ie run sub/userform) when i open the workbook.~? Thx again~
thank you~ But i am still confused in VBA and macro. I used the visual basic editor to create a form. and how can I open the form (ie run sub/userform) when i open the workbook.~? Thx again~
? -_-\ Aug 3, 2005 #5 Done~ thx a lot~ Bob Phillips said: Sub Auto_Open() Userform1.Show End Sub Click to expand...