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.