Sheets("Print Ticket").PrintOut Copies:=1, Collate:=True

This line alone should do the trick
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"sungen99" wrote:


The below macro works just fine when the worksheet is not hidden. But
when it is the macro bombs out.




Sub Button11_Click()
Sheets("Print Ticket").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Form").Select
Range("E9:F9").Select
End Sub


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=505722