auto run macros

[kendel]

Hello, I'm using MS XP and Exel 2007.
I want to run a macro automatically when the workbook is opened. I've read several solutions here but it seems like I missed the first half of the movie cause I can't seem to get it. Please explain it in a generic way, that would apply to any macro.
Thanks, Kendel

 

[VoG]

Press ALT + F11 to open the Visual Basic Editor. In the Project window double click ThisWorkbook and paste in

Private Sub Workbook_Open()
Call MyMacro
End Sub

Change MyMacro to the name of the macro that you want to run.

 

[kendel]

VoG, thank you! How to add more macros to the autorun? can I just list them:

call check
call sort
call format3

end sub
??
thanks again!!

 

[VoG]

Yep, just call them in the order that you want them to run.