Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Macro
I currently the following macro set up to print the active workbook. What do
I need to ad to this to exclude sheet 1?: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 21/03/2007 by me' ' ActiveWorkbook.PrintOut Copies:=1, Collate:=True End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Macro
One way is to build a list of all the sheets to be printed.
Another way is to hide the sheet, print the remainded and then unhide the sheet. worksheets("sheet1").visible = xlsheethidden ActiveWorkbook.PrintOut Copies:=1, Collate:=True, Preview:=true worksheets("sheet1").visible = xlsheetvisible (Preview:=true is nice for testing) The Rook wrote: I currently the following macro set up to print the active workbook. What do I need to ad to this to exclude sheet 1?: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 21/03/2007 by me' ' ActiveWorkbook.PrintOut Copies:=1, Collate:=True End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a print macro to print only a certain number of pages | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
Print Macro | Excel Discussion (Misc queries) |