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