title: Allowing the user to select the sheets to print
body: <p>I have a macro that creates reports based on employee name.  Each created report sheet is named with each employee's name.  I have it set up so that when the employee generating the report presses the print button, it only prints the active sheet.  This has to be done for each employee.  Is there a way in VBA that will allow the user to select one or more employee names (based on the sheet name) and print all reports in one print job?  Thank you in advance for your assistance.  This community has been a great help in the past and I know you will come through for me again.</p>