Userform to Select and Print or Export to PDF

I'm working to develop a userform for a Excel file that has about 50+ worksheets in it. The userform should provide a listing of all visible worksheets minus a couple of sheets that should never be printed (but can't be hidden)

I figured out how to list all of the worksheets in a multiselect check box and have created a couple of placeholder command buttons, one each to either print, or save/export to PDF. But I'm currently struggling with the command button code. I "think" I need to first group all the selected sheets into an array, and then print the array or export to pdf. It should work so that only 1 PDF file is created based on the selected sheets.

This is the basic form code thus far, but is still empty for the command buttons.

Can anyone provide some starter tips?
Also, is there a better way to group/code the worksheets that should not be included in the listbox?

Please Login or Register  to view this content.

Well,

Still unsure if I'm going in the right direction, but I worked some last night trying to place all the selected worksheets from the multi select listbox into an array of sheets. And would then eventually work to print or export that to PDF.

so this is my current (not working) but incomplete attempt thus far. I hope to read and explore some today if I can get some more time.

Please Login or Register  to view this content.

In a follow up from last night. While I thought the below was working correctly, it appears that when the print preview is loaded, Excel is only showing and then printing the first worksheet, and not all of the worksheets selected in the userform.

I'm off to google for more help. But how to you get all the selected worksheets to show in print preview and to print in one piece vs separate print jobs for each worksheet?

Please Login or Register  to view this content.