Select Sheets to include in PDF

  • Hi,


    I am new to vba, and generally stink at it. It takes me quite a bit of time to accomplish even the basics, but I get by. I am having trouble with the following:


    I need a userform to open which will display and allow me to add all of the sheets in the workbook to a PDF file. I'd ideally like to choose a filename/save location. (except for a few, which I do not want even accidentally printed or emailed).

    I have tried to adapt multiple piles of code that i have found on this and other forums, with no success. Can anyone point me in a direction? I have included the xlsm file for reference.XLProposals.xlsm


    I really am the guy who tries to take all the time needed before asking for help....so any help would be greatly appreciated.

  • Have a look at this example.


    You can add code to exclude sheets, but you didn't state any sheets.