Print Selected Sheets To PDF

I have a workbook that contains a different # of sheets at various times. I would like to write a macro that will do the following:

1) Select all visible sheets except for 3 sheets called "Setup" "Master" and "Stmt"
2) Print/Export the selected sheets as a single pdf
3) Name the pdf file based on the value in Setup sheet "A3" & "_" & value in Setup sheet "A5"
4) Save the pdf in the same directory as the active workbook.

Thank you in advance for your help.

You could try this.

Please Login or Register  to view this content.

Works great. Thank you.