Prev: xltm saveas xlsm
Next: Update pivot table report filter using cell value
From: Orion Cochrane on 2 Mar 2010 09:31
I have a spreadsheet that requires a constantly changing variable each time
it is printed. I have a cell with a batch number. For each copy I want
printed, this batch number should increase by one. I am able to do this for
single copy print jobs, but I can't figure out how to increase the number for
each copy for multiple copy print jobs.

I know to put this in a Workbook_BeforePrint event, which is the way I am
going. Maybe I need an InputBox to prompt the user to enter the number of
copies and loop it for each copy. Ideally, I do not want the Print Dialog Box
to display at the end.

TIA.
--
I am running on Office 2007, unless otherwise stated.
From: Orion Cochrane on 2 Mar 2010 10:03
Thanks. The second macro in Ron's page was exactly what I was looking for.
This isn't the first time he's saved me.
--
I am running on Office 2007, unless otherwise stated.


"Gord Dibben" wrote:

> See code at Ron de Bruin's site.
>
> http://www.rondebruin.nl/print.htm#same
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 26 Feb 2010 09:55:01 -0800, Orion Cochrane
> <OrionCochrane(a)discussions.microsoft.com> wrote:
>
> >I have a spreadsheet that, when I go to print it, increases a particular
> >cell's value by one. This works great for printing one copy. I need it to do
> >this for each copy printed. Ideally, I would like an InputBox prompting the
> >user to enter the number of desired copies, and it prints a page with the
> >increased value for each copy. I know I need a Do...Loop statement, but I
> >can't figure out how to write it. I want the InputBox to be just before the
> >Do...Loop statement, and I want the Print Dialog Box to not show up.
> >
> >All of this is in a Workbook_BeforePrint event.
> >
> >TIA.
>
> .
>
 | 
Pages: 1
Prev: xltm saveas xlsm
Next: Update pivot table report filter using cell value