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.
walterogAsked:
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'
0
 
FayazCommented:
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.
0
 
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?
0
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.