Printing an entire worksheet

  • Thread starter Thread starter cheetah
  • Start date Start date
C

cheetah

My questions is can you set Excel to always print every
sheet in all files? I know you can select Entire
Worksheet but I don't want to have to do this each time.
I want it always to print every sheet and this is for all
my files not just one file.
 
Could you have a macro do the work for you?

I got this when I recorded a macro and printed the whole workbook:

Option Explicit
Sub Macro1()
ActiveWorkbook.PrintOut Copies:=1, Collate:=True
End Sub

If you have this in a workbook that's open, you can hit alt-f8 and run it.
 
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 VBA - Problem with Closing Print Preview 0
Workbook Printing Problem 1
Print worksheet 2 on back of worksheet 1, etc.... 1
Print selected worksheets in multiple workbooks? 1
Blank Sheet with Gridlines 11
Problem printing all worksheets in colour 1
Not printing the entire workbook 2
Change multiple worksheets at one time to print in color 1

Back
Top