Printing

Posted by Kathi on December 14, 2001 9:49 AM

I have an Excel spreadsheet, that I have removed the toolbars. Is there a way that can I code a dialog box, which will allow the user a choice of printers to print to? I do not want to give them access to the toolbars.

Posted by Rick E on December 14, 2001 11:08 AM

Put a button on a dialog box (Form) and add the code:

x = Application.Dialogs(xlDialogPrint).Show

x is False if the user clicks the Cancel button.

You will get the Print Dialog box from Microsoft and the user can select from the printer list, number of copies, etc. It will then print the active sheet.

How's that? Rick E.