- Dec 23, 2013
I'm running Excel 2011 for the Mac. I recently learned through this forum how to, using VBA, bring up the print dialog box so the user can select printer, number of copies, etc (Application.Dialogs(xlDialogPrint).Show). Now I have a new question. I have a macro which I'm writing which will automate printing of multiple worksheets in a workbook. I'd like to be able to select multiple worksheets within the macro at the same time and then open the print dialog box once and have all of the print settings applied to the multiple worksheets. I know how to select one worksheet at a time and execute the print dialog box, but how do I select multiple worksheets at the same time prior to initiating the print dialog box?