Number of copies when printing

  • Thread starter Thread starter Ian James
  • Start date Start date
I

Ian James

Can anybody help...?

We are currently printing off a form that has been duplicated many
times to obtain answers to many questions in a way of collecting
clients requirements.

The problem is that whenever we print the form with the answers, the
default setting is 10 copies.

This is not the default setting on the printer and all other documents
from word, outlook etc, print just one copy. Is there a setting
somewhere within the excel file that is forcing the 10 copies...?

We did not generate the form originally and the company who did are
unable to answer our question.

Any help would be appreciated

Regards

Ian James
 
Open the file, open the vb editor(alt f11), click edit menu, find and search
for copies

If you find something like copies := 10 then replace it with
copies := 1


HTH

KenM
 
Back
Top