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
 
I use Report Manager. (You may need to install it form installation CD)
 
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...
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print Macro Help 1
A macro code to print multiple sheets in different w.books 3
Print worksheet 2 on back of worksheet 1, etc.... 1
Problem printing all worksheets in colour 1
I trying to develop a macro to print my worksheets 1
Print workbook tabs based on a selection list 1
Macro buttons for gray scale and color print 2

Back
Top