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.