macro for printing all worksheets

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

Is there a macro or other command that will print all
worksheets in a spreadsheet without having to print each
one individually?

Thanks,
Carrie
 
Hi Carrie

Try this

ActiveWorkbook.PrintOut
'the whole workbook

Worksheets.PrintOut
'all worksheets

Sheets.PrintOut
'all sheets

Sheets(Array("Sheet1", "Sheet3")).PrintOut
'all sheets in the array ActiveWindow.SelectedSheets.PrintOut
'print all selected sheets

ActiveSheet.PrintOut
'only the activesheet

Sheets("Sheet1").PrintOut
'only "Sheet1"

Selection.PrintOut
'print only the selection

Range("c1:d5").PrintOut
'print range
 
Without VBA Code You can just Group your Sheets (for contiguous sheets
click on the Sheet1 tab then holding down the Shift-key and clicking on the
Sheet99 Tab) All including the between tabs should be highlighted. Fill you
paper-tray and click print. Afterward click on any one of the tabs and
select Ungroup Sheets.
 
Afterward click on any one of the tabs

make that:

Afterward right-click on any one of the tabs...
 
Back
Top