Automatic Macros

[Diego]

Hey! I need some help form the pros, I need to create a
macro that runs automatically when the workbook in excel
opens, How do I do that? Thanks

 

[Stef C]

Use the Workbook_Open event of your workbook.

ex:
In your workbook VBA module

Private Sub Workbook_Open()

msgbox "Workbook Open!!!!!"

end sub

 

[Chip Pearson]

Diego,

You can name the macro Autpen. Alternatively, you can use the Open event
of the workbook. In the ThisWorkbook code module, use

Private Sub Workbook_Open()
' your code here
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Diego]

Thanks!!!! I tried naming it auto_open it worked. By the
way...How do I get to the this workbook code module? I
couldn't do it. Regards.

 

[Chip Pearson]

Diego,

You get to the ThisWorkbook module by first displaying the Project Explorer
window (View menu, Project Explorer, or just CTRL+R). Find your project in
the TreeView on the left side of the screen, and expand the folder. You'll
see a folder called "Microsoft Excel Objects". Expand that, and double click
the ThisWorkbook icon.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)