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

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

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?