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

"bj" wrote:

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

"KneeDown2Up" wrote:

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?