excel vba - Automatic Macro for every sheet -

i have method formattong excel sheet problem have 14 sheets , auto_open method working in sheet1 only?

is there way run method run everysheet automatically when open excel?

the best create function or sub called every "onopen" events of sheets.