View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How do I change the default number of copies to print to one?

Sorry,
I don't have other suggestion

"atropos557" wrote:

The printer's default is showing up as 1 copy. This problem only happens in
Excel and only with this one specific workbook.

"Eduardo" wrote:

Hi,
So try this
go to Control Panel, Printer and Faxes or Printers, then right click in the
mouse on the printer you are using, Printing preferences and see there is the
default is as 9

"atropos557" wrote:

There do not appear to be any macros in this workbook. When I go to the print
screen the number listed in "number of copies" is 9. In any other workbook,
the default has always been 1. I can't figure out what's different about this
particular file.

"Eduardo" wrote:

Hi,
When you say automatically is that with a macro, unless the macro specify #
of copies the default in excel is 1

"atropos557" wrote:

When I go to print a worksheet it automatically defaults to 9 copies. How do
I change this so it will go back to only printing 1? It's only one specific
file that has this problem.

Thank you!