How To create a VBA to print all reports from a drop down menu.
I am building a report card for athletes and I have made individualized reports based on their names allocated in the drop down menu.
I am unsure on how to print all these different reports without clicking on each athlete's name individually. I have had a previous report with a print all button in the developers tab but I am not sure where it went and how to create a new one.
Please help
Question
Hello,
It's hard to say for sure what you need to do without a few more bits of detail. Are these reports on separate sheets? And are all the sheets visible? If not, how are these reports structured in Excel? Screenshots would be helpful.
If you just need to print every sheet you can use this:
ActiveWorkbook.PrintOut
Thanks!