You need NOT select. Don't know about the macro you are calling but I
suspect you also need NOT select.

Sub printhiddensheet()
Application.ScreenUpdating = False
With Sheets("sheet10")
.Visible = True
.PrintPreview
.Visible = False
End With
Application.ScreenUpdating = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"EagerGit" wrote in message
...
hello there
I have macro assigned to a button in Sheet 1 which goes to sheet 2.
Press a button to Refresh and then PRINT preview

It does work in normal state.
I do not want the user to see the Sheet 2. I hid sheets from
Format-sheet-hide.
but the macro is not working when sheet 2 is hidden.
how to overcome this error
"can't execute code in break mode"

the macro code is

Sub Print_Preview()

Sheets("PaySlips2009-10").Select
Application.Run "'Latest 2009Payslip.xls'!Sheet2.HURows"
ActiveWindow.SelectedSheets.PrintPreview
End Sub