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.