VBA to Print Specific Sheet

[VinceF]

Greetings,

I've searched the forum but was unable to find something applicable to what I need.
I set up a button and would like to assign VBA to it for printing.

I have a workbook with 9 sheets. On the sheet named "Team Generator" when I select print preview it would print 3 pages. I'd like for it to only print page 3.

Your assistance is very much appreciated.

VinceF
Win 10
Excel 2016

 

[DanteAmor]

How about:

Sub Macro1()
  Sheets("Team Generator").PrintOut from:=3, to:=3, preview:=True
End Sub

 

[VinceF]

How about:

Sub Macro1()
  Sheets("Team Generator").PrintOut from:=3, to:=3, preview:=True
End Sub

Thank you for your reply.
When I run the code I get a Compile error invalid outside procedure error message
???

 

[Joe4]

Thank you for your reply.
When I run the code I get a Compile error invalid outside procedure error message
???

It looks like the "From" and "To" need to be capitalized, i.e.

Sub Macro1()
  Sheets("Team Generator").PrintOut From:=3, To:=3, Preview:=True
End Sub

 

[VinceF]

It looks like the "From" and "To" need to be capitalized, i.e.

Sub Macro1()
  Sheets("Team Generator").PrintOut From:=3, To:=3, Preview:=True
End Sub

Excellent...It's working great now
THANK YOU

 

[Joe4]

You are welcome.
Glad we were able to help.

 

[DanteAmor]

It looks like the "From" and "To" need to be capitalized, i.e.

That's weird, it works for me. Maybe it's the excel version