Default Settings in Backstage Print to "Print Selection

**excelforumkeys** · 06-10-2014, 01:03 PM

Hi all and thanks in advance for any help/info.

I've been Googling and Binging to the detriment of my fingertips and hope of finding an answer to the following situation.

I have a command button on a sheet with the following code that will select a range (sometimes fixed, sometimes dynamic) and take the user to the backstage Print section of Excel:

Please Login or Register  to view this content.

However, I need to add a line (or more?) of code to have the first Settings selection to default (or change) to "Print Selection" instead landing at its normal "Print Active Sheets".

Is this possible?

I do not want to use .PrintPreview for a number of reasons.

Appreciate any help!

Regards,
Chris

**Leith Ross** · 06-10-2014, 02:41 PM

Hello Chris,

If you don't need the user to set the default printout parameeters, you can do it directly using the Worksheet.PrintOut Method

The attached picture is from the VBA help files.

**excelforumkeys** · 06-10-2014, 03:15 PM

Thanks for the quick response and suggestion Leith, but I believe need the user to be in the Backstage environment where they can change printers or print it to a PDF (options available in our workplace setup).

Correct me if I'm wrong, but if I use .PrintOut, the Preview option will ultimately use .PrintPreview functionality and that doesn't allow much flexibility to make changes to printers and only provides the printing option of the active/default printer on their machine.

My thought was if I have the code make the selection to print, take them to the backstage print section under File, and have the Settings selected to "Print Selection" when they get there, they'll see the desired output and then all they need to do is determine how many copies they need, which printer to use, etc. Changing to Print Selection from Print Active Sheets just isn't very intuitive for most in our work environment.

Thoughts? Other suggestions?

Thank you and appreciate your insight!
Chris

**Leith Ross** · 06-10-2014, 06:12 PM

Hello Chris,

You can present the user with the print dialog box with this line of code...

Please Login or Register  to view this content.

Default Settings in Backstage Print to "Print Selection

LinkBack

Thread Tools

Rate This Thread

Display

Default Settings in Backstage Print to "Print Selection

Re: Default Settings in Backstage Print to "Print Selection

Re: Default Settings in Backstage Print to "Print Selection

Re: Default Settings in Backstage Print to "Print Selection

Thread Information

Users Browsing this Thread

Similar Threads

Making "Selection" the default in print dialog box?

[SOLVED] How can I have Excel default the "Print What" to be the Selection

Print Default settings

[SOLVED] Print Default Settings

[SOLVED] Setting to default Print Settings

Bookmarks

Bookmarks

Posting Permissions