MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Problem of Auto Select for Printer By VBA


Posted by Oscar on December 18, 2000 8:20 PM

1) May I know how to auto select the custom paper size for printing by VBA,please?
2) Can I use the manual tray for sheet1 print and use the back tray for sheet2 to print by VBA?How?
Thanks
Regards
Oscar


Posted by David on December 19, 2000 11:37 PM

try recording your actions and see it this helps you also

Application.Dialogs.Item(xlDialogPrint).Show

sorry if no help