print defaults at 20 copies

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet, with VB code. Everytime I go to print, the default
number of copies is 20. If I change this to 1, and then save, it still comes
up as 20 the next time I go into the print menu. There is no VB code relating
to printing. Can anyone help please?
 
this sounds like a printer driver issue, not an Excel issue
to check if it is an excel issue, open excel in safe mode and print a
document.
otherwise go to your printer control and check to see what it has as copies
 
additional questions
is this on all sheets or just one
does it do this with a new book or just one
if it is just one sheet right click on the tab and select view code
there may be a macro on that sheet for before_print
 
Back
Top