Save Workbook as PDF but only selected sheets and multiple copies

[sanjagani]

I am impressed with the code
http://spreadsheetpage.com/index.php...eets_to_print/

this enables to print selected pages using default printer.

I need few changes.

I want a macro to save selected worksheets from active workbook as PDF. also want Sheet 5 and Sheet 6 seven times each on same PDF file.

Appreciate your efforts in helping me solve the challenge.

 

[sanjagani]

I forgot to mention: I use Excel 2007