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

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

"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



try unhiding the sheet whilst it is printed and then hiding it again

E.g

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

hope this helps

Thank you all!


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

Hi Sungeri,

Try removing the selection:

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

Selections are rarely necessary and are often inefficient.

---
Regards,
Norman



"sungen99" wrote in
message ...

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

try this from anywhere in the workbook. Selections are NOT necessary.

Sub printhiddensheet()
Application.ScreenUpdating = False
With Sheets("sheet8")
.Visible = True
.PrintOut
.Visible = False
End With
Application.ScreenUpdating = True
End Sub

--
Don Guillett
SalesAid Software

"sungen99" wrote in
message ...

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