Run all vba at once after opening excel file
Closed
eunice3301
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
-
Jul 31, 2017 at 03:40 AM
eunice3301 Posts 13 Registration date Thursday July 27, 2017 Status Member Last seen August 29, 2017 - Aug 1, 2017 at 12:58 AM
eunice3301 Posts 13 Registration date Thursday July 27, 2017 Status Member Last seen August 29, 2017 - Aug 1, 2017 at 12:58 AM
Related:
- Run all vba at once after opening excel file
- How to enable vba in excel - Guide
- Number to words in excel without vba - Guide
- Excel date format dd.mm.yyyy - Guide
- How to open .msi file - Guide
- Vba case like - Guide
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
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
eunice3301
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
Aug 1, 2017 at 12:58 AM
Aug 1, 2017 at 12:58 AM
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=)
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=)
