Auto run macro on file opening

[Chuck31]

Hi,

is there a way to autorun a macro on file opening ?
if so, what's the vb code.

Regards,

[debauch]

In the code view (right click a tab, "view code")
Then double-click on 'thisworkbook'
and put in following code :

Private Sub Workbook_Open()
Call macro_name
End Sub

[Chuck31]

Thanks, is there a way by the same time to minimize or hide sheets in the workbook ?