Printing Autonumber

[Ann Shaw]

Hi
I got help on this question earlier from Don - great!
I set up the order number on a spreadsheet to print and
change the number each time.

The problem I have come up with now is that some of the
users of the sheet want to set print 10 copies so that the
number is printing 10 times instead of changing each time.
They do not want to have to click File Print 10 times if
they want 10 copies - am I making this clear??

Don very kindly gave me the code:
sheets("sheetname").range("rangename")=sheets
("sheetname").range("rangename")+1
Every time I click the printer icon the number changes
automatically - this is excellent - but is it possible to
do this while printing 10 copies??

Thanks

Ann

 

[Jim Rech]

If I understand you, users should use File, Print and set the number of
copies to print there.

--
Jim Rech
Excel MVP


| Hi
| I got help on this question earlier from Don - great!
| I set up the order number on a spreadsheet to print and
| change the number each time.
|
| The problem I have come up with now is that some of the
| users of the sheet want to set print 10 copies so that the
| number is printing 10 times instead of changing each time.
| They do not want to have to click File Print 10 times if
| they want 10 copies - am I making this clear??
|
| Don very kindly gave me the code:
| sheets("sheetname").range("rangename")=sheets
| ("sheetname").range("rangename")+1
| Every time I click the printer icon the number changes
| automatically - this is excellent - but is it possible to
| do this while printing 10 copies??
|
| Thanks
|
| Ann

 

[Ann Shaw]

Yes Jim that is correct.
At the moment they have to click File - Print and print
each sheet separate for the autonumber to work. This has
been entered as code using the before print option.

I was just wondering if the user could click File-Print -
number of copies eg: 10 and then if the number on the
sheet would still increment.

Thanks

 

[Jim Rech]

I was just wondering if the user could click File-Print -
number of copies eg: 10 and then if the number on the
sheet would still increment.

Ahh, well I don't see how that is possible. The Before_Print event (which I
assume you are using to increment the counter) is only called once.

If you created your own "print menu" (with a userform) you could let users
pick a number of copies and then print each one for them, incrementing the
counter.

 

[Ann Shaw]

Hi Jim

Is it difficult to create a print menu with a userform?
I will certainly experiment.

Thanks

Ann