how to make macro work even a sheet is hidden.
 

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

how to make macro work even a sheet is hidden.
 

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

how to make macro work even a sheet is hidden.
 

Try this:


Sub Print_Preview()

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







"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

how to make macro work even a sheet is hidden.
 

thank you both.
I have merged both of yours code togather and it is working.
I have to insert the .select as it was not giving preview of the payslips
but of the ACTIVe sheet where the button is.

final working code

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



"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