print specific worksheets in specific order.

Please could someone help me with this issue?

I have a workbook with 80 worksheets, I would like to print these worksheets in various different combinations to a single PDF. (I have Adobe Acrobat 7.0 installed.)
I would like to have 7 buttons that when pressed will print the specific combination of worksheets in a specified order.

(Button 1) Print Worksheets: 1,2,3,4,5,6,7,8,9,10,11,12
(Button 2) Print Worksheets: 13,14,15,16,17,18,6,7,8,19,20,21,22,23,24,25,26
(Button 3) Print Worksheets: 27,28,29,30,31,32,,6,7,8,33,34,35,36,37
(Button 4) Print Worksheets: 38,39,40,41,42,43,6,7,8,44,45,46,47,48,49,50,51,52,53,54
(Button 5) Print Worksheets: 55,56,57,58,59,60,6,7,8,61,62,63,64,65
(Button 6) Print Worksheets: 66,67,68,69,70,71,6,7,8,72,73,74,75,76,77,78,79,80
(Button 7) Prints all worksheets.

So when each button is pressed it will create a single pdf combining the specific worksheets in the correct order.

jarvo,
For each button, set the required sheet numbers, e.g:

Sub Button2_Click()
Dim PagesToPrint As Variant
PagesToPrint = Array(13,14,15,16,17,18,6,7,8,19,20,21,22,23,24,25,26)
Call ArrayPrint(PagesToPrint)
End Sub

Private Function ArrayPrint(argPages As Variant) As Boolean
ThisWorkbook.Sheets(argPages).PrintOut ActivePrinter:="Adobe PDF on Ne02:"
End Function

Not sure what the "*"'s are supposed to mean, but..

NickHK

"jarvo" <jarvo.25umbb_1144336809.2514@excelforum-nospam.com> wrote in
message news:jarvo.25umbb_1144336809.2514@excelforum-nospam.com...
>
> Please could someone help me with this issue?
>
> I have a workbook with 80 worksheets, I would like to print these
> worksheets in various different combinations to a single PDF. (I have
> Adobe Acrobat 7.0 installed.)
> I would like to have 7 buttons that when pressed will print the
> specific combination of worksheets in a specified order.
>
> (Button 1) Print Worksheets: 1,2,3,4,5,6,7,8,9,10,11,12
> (Button 2) Print Worksheets:
> 13,14,15,16,17,18,*6,7,8*,19,20,21,22,23,24,25,26
> (Button 3) Print Worksheets: 27,28,29,30,31,32,,*6,7,8*,33,34,35,36,37
> (Button 4) Print Worksheets:
> 38,39,40,41,42,43,*6,7,8*,44,45,46,47,48,49,50,51,52,53,54
> (Button 5) Print Worksheets: 55,56,57,58,59,60,6,7,8,61,62,63,64,65
> (Button 6) Print Worksheets:
> 66,67,68,69,70,71,6,7,8,72,73,74,75,76,77,78,79,80
> (Button 7) Prints all worksheets.
>
> So when each button is pressed it will create a single pdf combining
> the specific worksheets in the correct order.
>
>
> --
> jarvo
> ------------------------------------------------------------------------
> jarvo's Profile:
http://www.excelforum.com/member.php...o&userid=18983
> View this thread: http://www.excelforum.com/showthread...hreadid=530521
>