| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printout method: in color, duplex
I am using the following code to printout a worksheet and am having
some problems. 1. I cannot get it to print in color. Is there a way to specify this inside of the .Printout method. 2. I cannot get it to duplex. Is there a way to specify this? I have my printing preferences set to both of these settings. ActiveSheet.Range("A1:G53").PrintOut , Copies:=2, preview:=False, ActivePrinter:="\\HaddonSrvr\Ricoh 2232C", printtofile:=False, Collate:=True, prtofilename:=PSFileName Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please post this thread a correct full method, method about | New Users to Excel | |||
| Any method to set cell background color conditionally ? | Excel Discussion (Misc queries) | |||
| Any method to set cell background color conditionally ? | Excel Worksheet Functions | |||
| Problem with the PrToFileName parameter when using the Printout method on a worksheet | Excel Programming | |||
| Excel vba printout method | Excel Programming | |||
Threaded Mode
