Printing multiple worksheets in 2000

  • Thread starter Thread starter Mary Metcalf
  • Start date Start date
Hi Mary

Select the Sheets you want(hold the Ctrl key when you select them) and print
Don't forget to ungroup

Or use this macro lines

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"
 
Back
Top