Checkboxes not selecting sheets for PDF generation

Hello All,

I have a an Active X Button that when clicked brings up a Userform with checkboxes for each sheet in my workbook. What I am trying to do is allow the user to select which sheets they want to generate into a PDF. Currently, regardless of what checkboxes are selected once the user hits the enter button that generates the PDF, all the sheets in the workbook are included in the PDF not what was selected. So please if you could let me know what I am doing wrong with my code and why the checkboxes are not selecting the sheets I want to be generated into a PDF. Thanks in advance for all help!

Please Login or Register  to view this content.