Choosing a Printer


Posted by Paul Magruder on December 18, 2000 6:04 AM


I am sending a workbook with a dialog box to several users. They need to be able to "choose" a printer when sending the form to print. Can you please tell me the code that launches the print option? I know code needed to print, but the code I have specifies one printer. I need the user to be able to choose the printer.

I am using Windows NT with Excel 97

Thanks in advance
Paul Magruder

Posted by CPod on December 18, 2000 7:11 AM

Application.Dialogs.Item(xlDialogPrint).Show



Posted by Paul Magruder on December 19, 2000 11:40 AM


Thanks....Just what I needed...
Paul Magruder