Macro to PDF multiple tabs and save in same file as the template is saved in

I have used a macro to PDF a tab which allows the PDF to be saved in whichever folder I need it to be. However, it doesn't contain a code that spells out which tabs that need to be a PDF. Can anyone provide a code that can do both? Essentially, I have a template that gets re-saved to several client files during the day and when they pdf a certain selection of tabs this PDF needs to be saved in the same place as the re-saved excel spreadsheet. In addition, I'd like the PDF to reflect the same name as the excel file.

please provide the code that you are using currently.

we can add one to few line to do what you request.

*remember to surround your code with

Please Login or Register  to view this content.

or click # in the format option.

I have tried to post the code by I receive this error: "You are not allowed to post any kinds of links, images or videos until you post a few times."

I also began and ended the post with pressing the # format button to produce code "

Please Login or Register  to view this content.

" like you suggested.

sorry is "[ CODE ]your code[ /CODE ]"(without space) instead. post#2 is autohide it...

you may upload workbook (that contain the code and replace sensitive data with dummy data) through :
go advanced > management attachment > upload

I have uploaded my spreadsheet via manage attachments. It is called "PDF Macro Example Code."

Thanks!