print defaults at 20 copies

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?
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cant print multiple copies of a worksheet 2
Printing multiple copies 1
Default Printer 2
Scaling in Excel 1
Print Copy limit 8
Change default print settings Excel 2007 6
Copy of VB code to new spreadsheet 6
Numbering rows when printing 7

Top