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.
Who is Participating?
Davy2270Connect With a Mentor Commented:
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'
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.