Hi, hope I'm posting this in the correct area!

I have an Excel Workbook that has 18 seperate worksheets in it.
I would like to write a macro so that users are presented with a menu after
selecting a 'PRINT' control button giving them the option of printing their
chosen selection of worksheets and the quantity of each, e.g. print 1 copy of
each; print 1 copy of the first 4 worksheets, 2 copies of the next 3
worksheets, then 1 copy of the remaining worksheets; print only worksheets 5
to 7.

The worksheets are all individually sized to fit and page setup to output to
A4 so I've cracked that bit - it's the macro to do the clever stuff I'm stuck
on.

Thanks in advance.

Probably the easiest way will be to create a dedicated worksheet for setting
up your printing. On that sheet list all of the tabs and next to each a spot
to fill in the desired number of sheets. Now just add a command button to
that sheet for printing. Traverse down the list of sheets printing each the
appropraite number of times. If you need help with that just reply back...
--
HTH...

Jim Thomlinson


"PhillyD" wrote:

Hi, hope I'm posting this in the correct area!

I have an Excel Workbook that has 18 seperate worksheets in it.
I would like to write a macro so that users are presented with a menu after
selecting a 'PRINT' control button giving them the option of printing their
chosen selection of worksheets and the quantity of each, e.g. print 1 copy of
each; print 1 copy of the first 4 worksheets, 2 copies of the next 3
worksheets, then 1 copy of the remaining worksheets; print only worksheets 5
to 7.

The worksheets are all individually sized to fit and page setup to output to
A4 so I've cracked that bit - it's the macro to do the clever stuff I'm stuck
on.

Thanks in advance.

Hi Jim,

Thank you for the reply. It sounds exactly like what I'm looking for, I had
thought of putting the control button on the worksheet called 'Input' as this
is the only sheet users need to access to populate the document.

You said to reply if I needed more help - my knowledge of macros is
rudimentary at best so yes please, your help would be greatly appreciated.

Thanks,

Phil