I excel if I record a macro of doing this...
or do it manually (Select all sheets.. the pagesetup) it hits all the sheets.

In my VB app it doesnt hit anything but the first sheet!???

VB Code:
  1. Private Sub PrintSetup()
  2.  
  3. For X = 1 To WKBK.Worksheets.Count
  4.     WKBK.Worksheets(X).Select Replace:=False
  5. Next
  6.     WKBK.Worksheets(1).Activate
  7.     With WKBK.ActiveSheet.PageSetup
  8.         .PrintTitleRows = HeadRow '"$3:$12"
  9.         .PrintTitleColumns = HeadCol '"$A:$A"
  10.         .LeftHeader = ""
  11.         .CenterHeader = ""
  12.         .RightHeader = ""
  13.         .LeftFooter = ""
  14.         .CenterFooter = ""
  15.         .RightFooter = "Page &P"
  16.         .LeftMargin = Application.InchesToPoints(xlsLeft)
  17.         .RightMargin = Application.InchesToPoints(xlsRight)
  18.         .TopMargin = Application.InchesToPoints(xlsTop)
  19.         .BottomMargin = Application.InchesToPoints(xlsBottom)
  20.         .HeaderMargin = Application.InchesToPoints(xlsHeader)
  21.         .FooterMargin = Application.InchesToPoints(xlsFooter)
  22.         .PrintHeadings = False
  23.         .PrintGridlines = False
  24.         .PrintComments = xlPrintNoComments
  25.         .PrintQuality = 600
  26.         .CenterHorizontally = False
  27.         .CenterVertically = False
  28.         .Orientation = xlLandscape
  29.         .Draft = False
  30.         .PaperSize = xlPaperLetter
  31.         .FirstPageNumber = xlAutomatic
  32.         .Order = xlDownThenOver
  33.         .BlackAndWhite = False
  34.         .Zoom = xlsZoom
  35.     End With
  36. End Sub