Event Macro to other other Macros each time the work book is opened

[Mldeuser]

I have various macros that need to be ran each time the workbook is opened is there a way to create an event macro that will do this for me.

Thanks
Mark

 

[VoG]

Right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_Open()
Call mymacro1
Call mymacro2
'
'and so om
'
End Sub

Change the names of the macros to the ones you want to run.

 

[Mldeuser]

I searched online for some information on how to do this and played around for quite a while with no success.

Thank you for this it works great.

Mark