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