• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Automatically print 2 pages in Excel 2010

I have a user that brought up an interesting question.  When printing in Excel 2010, is it possible to set a specific number, as the default for “printer copies.”  This user always prints 2 of everything… I’m curious to see if it’s possible to set your printer to print 2 of everything-every time.
1 Solution
In the printer configuration, default settings you can set the nuber of printouts. But this will always print two copies, regardless from any program.  Or you can create a tempate and set the print options and open the files through the template, when printed it will print two copies.
walterogAuthor Commented:
Thanks for the quick response. Okay I've modified the printer configuration to print 2 copies. Now the issue is excel is changing it back on its own.

I am using windows 7, MS suite 2010. Under device and printers I am making the changes to a specific printer, I apply and it it stays. When i try to print to the printer from excel it doesn't follow through with the changes. I have to do it manually through printer properties-advance tab.

any ideas?
3 Steps to follow:
1. Set up or modify your PERSONAL.XLSB file (Google for how to set it up).

2. Then copy the following simple macro:

Sub PrintTwice()
       ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True
End Sub

3. Customize the quick access toolbar with a command related to the macro 'PrintTwice'

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now