Printing multiple worksheets in 2000

  • Thread starter Thread starter Mary Metcalf
  • Start date Start date
M

Mary Metcalf

How do I print multiple worksheets as one print job in
Excel 2000?
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem printing all worksheets in colour 1
Printing Excel Multiple Copies 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copy print area to multiple worksheets 1
Excel VBA - Problem with Closing Print Preview 0
A macro code to print multiple sheets in different w.books 3
Printing whole workbooks on one sheet of paper 1
Printing Copies or multiple worksheets produces mult jobs 2

Back
Top