Saving Worksheets as individual PDF files base on checkbox selection.

[stirlingmw]

Afternoon All

I have the following code that generates a New folder based on a cell value and then splits the Workbook into separate tabs and saves each one as a PDF file using the Tab name as well as other data from a Data worksheet as the file name.
Some of the worksheets are not required and not all of the other worksheets are required all the time. Is there a way I can modify the code below to only save the tabs indicated by checkboxes from a Userform, Checkbox1 = Sheet1, Checkbox2 = Sheet2, Checkbox3 = Sheet3, Checkbox4 = Sheet4, any combination of these.

Please Login or Register  to view this content.

thanks in advance.

Steve

[Bernie Deitrick]

If you add a conditional into your loop, along the lines of this:

Please Login or Register  to view this content.

[stirlingmw]

Thank you for you tips, i have been trawling this site and others and have change the code. I now have a Userform with 4 checkboxes, each referring to a Worksheet. If the checkbox is true then that worksheet is saved as a PDF in a folder also generated at the time of export.

Please Login or Register  to view this content.

Not the neatest of code, but does the job.

Thanks again.

Steve

[Bernie Deitrick]

"Does the job" is the only requirement for code, as far as I'm concerned Congrats!