Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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.

Re: Printing from a dialog box...

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.