Quote Originally Posted by Paul_Hossler
My test workbook had Sheet1, ..., Sheet5; if you want to try this, you'd need to adapt it to your names.

Similarly, the PDF "printer" here is configured differently.

I was testing if it were possible to select multiple worksheets and then print them to one PDF file using a single "Print" instead of trying to print individual sheets and joining them into a PDF
I did the adaptation with the names, that was my test situation..... this isn't as easy as thought.

@ charlize, there seems to be no activity in pdfcreator, it saves nothing, but also there is no doc qeued