Report

Run all vba at once after opening excel file

Ask a question eunice3301 11Posts Thursday July 27, 2017Registration date August 20, 2017 Last seen - Last answered on Aug 1, 2017 at 12:58 AM by eunice3301
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


See more 
Helpful
+1
plus moins
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
Leave a comment
Helpful
+0
plus moins
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=)
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!