Auto start vba

[sms2luv]

I have several code in my sheet which I want to start automatically when excel file is opened.
Like
Message box.
Switch to Help sheet.
Auto filtering tables.
Check if macro is enabled.
Refresh pivot.
Timer code as in http://forum.chandoo.org/threads/timer-code.35345/#post-211429

Can I put all of this in 1 module named as auto open, so that all codes are fired automatically

 

[YasserKhalil]

In standard module you can use code like that

Sub auto_open()
    Call macro1
    Call macro2
    'And so on .. You can use Call then the subroutine name
    'Or you can type the subroutine directly
End Sub

Or in thisworkbook module you can use the code in this way too

Private Sub Workbook_Open()
    Call macro1
    Call macro2
    'And so on .. You can use Call then the subroutine name
    'Or you can type the subroutine directly

End Sub

 

[sms2luv]

SOLVED

 

[YasserKhalil]

Great