VBA Best way to auto run all macros on a sheet when file is opened

[LNG2013]

I am reworking some of my previous code and would like to have it so that when the file is opened it runs all the macros in the workbook.

How do I go about doing this?

 

[ADeYoung]

In VBA, select ThisWorkbook in your VBAProject window and enter the following:

Sub Workbook_Open()

Run ("Your Macro #1 Here")
Run ("Your Macro #2 Here")
Run......for as many macros as you need to run on open

End Sub

 

[LNG2013]

Ok this works but is there a better way to have the first book run than to change the first Sub to Auto_Run?

In VBA, select ThisWorkbook in your VBAProject window and enter the following:

Sub Workbook_Open()

Run ("Your Macro #1 Here")
Run ("Your Macro #2 Here")
Run......for as many macros as you need to run on open

End Sub

 

[ADeYoung]

Not sure what you are asking there?? Can you explain?

 

[Ruddles]

Ok this works but is there a better way to have the first book run than to change the first Sub to Auto_Run?

No. There are different ways, but they're not better.

Incidentally, books don't 'run'. I assume this was a type for 'macro'.