Printing a hidden sheet

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

I think its because It's trying to go to the Print Ticket woorksheet right?


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

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!

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
[email protected]
"sungen99" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>