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.