• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Print or Save as a PDF for each item in Pivot Slicer using VBA with Single Click Button


Hi Experts,

I have 20 items in the slicer pivot. Therefore, I want to print or save as a PDF for each item (in a separate file), as you can see in the tab sheet "Report" on my excel file (Sample.xlsx) below.
Is there any code to run this?

Your kind attention is really appreciated. Thank you in advance!



New Member
Select a file in any application that prints and open it.
Choose “File” > “Print”.
Choose “Adobe PDF” from the list of printers in the print dialog box.
Click "Print" to use the Acrobat PDF printer.
Click “OK” and enter a new file name for your PDF. Save to your desired location.

Hope This Works,