View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sha sha is offline
external usenet poster
 
Posts: 3
Default 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