View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Print page 1 of all work sheets??

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 wrote:

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