Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
How to make userform work publically with hidden sheets? | Excel Discussion (Misc queries) | |||
How to make userform work publically with hidden sheets? | Excel Worksheet Functions | |||
How to make userform work publically with hidden sheets? | Excel Programming | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |