Run all vba at once after opening excel file

[Closed]
Report
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
-
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
-
Hello,

Please help me. I want to run the macros at once after opening the excel file.

I have different codes in each sheet.

Please i need your help guys.

Thank you


2 replies


You wold have to run a master procedure, and call of them upon, Workbook_Open() event.

So, in others words, if you have a module, that contains 5 subroutines, you would need to do the following:

private sub mastersub()
call subone
call subtwo
call subthree
call subfour
call subfive
end sub

private sub Workbook_Open()
call mastersub
end sub
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017

Thank you so much mark. I also tried this

Private Sub Auto_Open()
Run ("Sheet3.Auto_Open")
Run ("Sheet5.Auto_Open")
Run ("Sheet6.Auto_Open")
End Sub

and it works.

I will try your suggestion. Thank you so much for the help=)