Print page 1 of all work sheets??

Rajula · May 4, 2006

Hi There,

Is there an option in Excel to print only the first page of all the
worksheets in the workbook.

Kind Regards
Rajula

Dave Peterson · May 4, 2006

You could run a little macro:

Option Explicit
Sub testme()

Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.PrintOut from:=1, to:=1, preview:=True
Next wks

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Rajula · May 4, 2006

First of all Thankyou Very much..It works fine..
Can i avoid the print preview & send it directly to the printer.

I have no clue about macros & VB..

Dave Peterson · May 4, 2006

Just delete this portion:

", preview:=True"

I like to save a few trees when I'm testing.

Rajula · May 4, 2006

It was just perfect..
Thanks again.

Dave Peterson said:
Just delete this portion:

", preview:=True"

I like to save a few trees when I'm testing.

Rajula · May 30, 2006

Hi,

In extention to the same problem.
This file is being used by people sitting in the US & UK. People in the US
use A3 size paper for printing.

What is the code for printing in A3 format if the file is getting printed
form US & A4 size if the file is getting printed from UK.

Regards

Rajula said:
It was just perfect..
Thanks again.