Application.dialogs xldialogprintersetup .show excel

If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Dialogs xlDialogPrinterSetup. Thread starter pcc Start date Apr 11, Joined Jan 21, Messages 1, Show I got his piece of code some time ago from the message board thanks to TsTom and it works fine.

However, does anyone know how to change the caption from "Printer setup" the default , to a user-defined one such as "Please select a printer and All suggestions appreciated Thanks. Excel Facts. Is there a shortcut key for strikethrough? Click here to reveal answer. When you use hashmarks to count is 4, strike through to mean 5. Joined Feb 8, Messages 11, I don't know of any way to do this, because that's a builtin dialog. Joined Mar 20, Messages 1, Hi pcc, My opinion is same as JP, so it's just my suggestion, why don't you use Userform before show a builtin dialog like this?

Hide Application. Show label1. ActivePrinter Me. Show End Sub. I've been looking into this and I found this page. Thanks for your attention guys. The userform approach suggested by Colo is exactly what I need, and I shall use this code in my application.

One other query. I have used Colo's code to get a list of printers on my userform. I have a commandbutton that is clicked to set the activeprinter to the listbox text I used a listbox rather than a combobox Application.

Can anyone please help?? Click to expand Thaks Colo. Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 3 years, 3 months ago. Active 10 months ago. Viewed 13k times. My abbreviated code is: Application. InchesToPoints 0. Kait Kait 41 1 1 gold badge 1 1 silver badge 4 4 bronze badges. Thanks for the reply! Those solutions only allow me to change PAGE specific settings That could help with the color printing, but that actually would resolve itself if I could get it to send to the right printer, which defaults to color.

And how do I tell that printer to print duplex? After looking through those, I'm definitely closer. I exported the active printer name to a cell I also added "Application. Show" before my PrintOut command so that at least allows me to go into the printer settings and set duplex before the print preview. So this is a viable workaround, though I'd still prefer to hard-code duplex printing in so I don't have to change the settings each time.

Show 4 more comments. Active Oldest Votes. Partial solution: Color settings can be done through Page Setup The ActivePrinter declaration in my PrintOut call was not working because I did not have the printer name exactly as the system wanted it.

ActivePrinter To output to a cell so you can copy-paste the text: Sheets "Sheet 1". Range "A1". ActivePrinter As a workaround for changing the printer settings to duplex: Change the active printer and open the print dialog box before the PrintOut command: Application.

Current code: 'Set print settings Application. Show 'Send to printer preview first ws. Add a comment. Sub A4DocuPrinter Application. Range "D9". Value ActiveWindow. PrintPreview End Sub.