Automating through sub activities

[jlister]

I currently have a series of VBA scrips relative to one spreadsheet and in order for each aspect to work, I need to go to each individual "sub" and press F5.
Is there any way to automate this so that the system walks through each activity is sequence?
Thanks in advance

 

[Akuini]

You can run a Sub or multiple Sub from another Sub, like this:

Sub try()
 try1
 try2
End Sub

Sub try1()
Debug.Print "A"
End Sub

Sub try2()
Debug.Print "B"
End Sub

if you run Sub try, it will run sub try1 & try2.

 

[jlister]

You can run a Sub or multiple Sub from another Sub, like this:

Sub try()
 try1
 try2
End Sub

Sub try1()
Debug.Print "A"
End Sub

Sub try2()
Debug.Print "B"
End Sub

if you run Sub try, it will run sub try1 & try2.

Thanks. Where do I put these in relation to my current script?

 

[Akuini]

Create a new sub in the same module as your current script. And just write in it your subs name that you want to run sequentially.

 

[jlister]

Create a new sub in the same module as your current script. And just write in it your subs name that you want to run sequentially.

Tried that.
Sub try()
try1
try2
try3
try4
try5
End Sub

and renamed my Subs - Sub1, Sub2 etc to Sub 5

get an error message "Sub or Function not defined"
Any ideas?

 

[Akuini]

and renamed my Subs - Sub1, Sub2 etc to Sub 5

You don't need to rename your subs, what are their original names?