printing SS question

[Brown]

I have been making a SS to track some data, and with help from you guys I have it complete.
Once the data is input I need to print the SS. I simply made sure wverything was working on one sheet with in a printable page, so it does not bleed to another page and print just a portion of the SS.
Is there a way to make the SS print on one sheet if I make the SS and chart larger than one page on the screen (in other words if I show the page breaks on the screen and I go over them)? I hope that made some sense.
Thanks
Brown

 

[Warship]

Try:

Sub PrintToOnePage()
  With ActiveSheet
    With .PageSetup
      .PrintArea = ""
      .Zoom = False
      .FitToPagesWide = 1
      .FitToPagesTall = 1
    End With
    .PrintOut
  End With
End Sub

 

[Brown]

Ok Thanks, but dumb question; where would I put that code? This is a realm I have never before been to.
Thanks and I look forward to trying it.
Brown