Print Macro - print multiple worksheets into 1 pdf based upon cell references

[mbartel]

Using Microsoft excel 2010 - I have 5 worksheets within one file. I am able to combined and print all worksheets into one pdf, however, I'd like to the option to include or exclude any of these 5 worksheets based upon a cell reference for each. If cell is "Yes" for sheet1 then include that worksheet in the pdf, if cell reference is "No" for sheet2, then do not include that worksheet. Therefore the pdf file can be any where from 1 to 5 pages assuming each worksheet is 1 page. Any help is appreciated.