| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deselecting sheets after the PrintOut method
I'm using the PrintOut method for the Sheets collection object to print
a selected subset of sheets at once. Sheets(Array("Chart A", "Chart B", "Sheet X", "Chart C")).PrintOut Copies:=1, Collate:=True They print just fine, but the sheets remain selected afterwards. How can I deselect the sheets? Thanks, John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deselecting sheets after the PrintOut method
Hi John
Sub test() Dim x As String x = ActiveSheet.Name Sheets(Array("Chart A", "Chart B", "Sheet X", "Chart C")).Printout Sheets(x).Select End Sub -- XL2003 Regards William wrote in message oups.com... I'm using the PrintOut method for the Sheets collection object to print a selected subset of sheets at once. Sheets(Array("Chart A", "Chart B", "Sheet X", "Chart C")).PrintOut Copies:=1, Collate:=True They print just fine, but the sheets remain selected afterwards. How can I deselect the sheets? Thanks, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with Printout Method | Excel Programming | |||
| PrintOut Method, Set ActivePrinter with a variable | Excel Programming | |||
| Printout method: in color, duplex | Excel Programming | |||
| Problem with the PrToFileName parameter when using the Printout method on a worksheet | Excel Programming | |||
| Excel vba printout method | Excel Programming | |||
Linear Mode
