| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing worksheet with printer tray # 3
Hi,
I have laser printer with 3 trays, two for letter size paper (tray # 1 and # 2) and one for legal size paper (tray # 3). I have as the default tray # 1, but I want to develop a macro to print in tray # 3 every time I press <Ctrl-I. As far as I know I can use the "ActiveSheet.PrintOut" command to print the active sheet, but I do not know how to specify tray # 3, Can you help me? Thanks, Salvador Hernandez |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing with B&W printer | Excel Discussion (Misc queries) | |||
| Use VBA to access Printer Properties (Resolution, Tray etc) | Excel Programming | |||
| Printing Text to Printer | Excel Programming | |||
| Printing To A Specified Printer | Excel Programming | |||
| I can't quite get the syntax for printing to the manual feed tray | Excel Programming | |||
Threaded Mode
