Print Multiple Worksheets from One Print Dialog Box

[allenpierce]

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?

 

[Drrellik]

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select for your VBA if the sheets are all the same

 

[allenpierce]

Thanks. Just what I was looking for.

 

[Drrellik]

your welcome. and welcome to the forum