• 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

    Hui...

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

Disable "Select Multiple Items" in a pivot table?

dronka

dronka

Member
I don't want my users to be able to select multiple items in a pivot table. Does anyone know of a simple way to disable this option in the pivot filter/slicer?

Thanks!
 
Dear Dronka

You can disable multiple selection option in Pivot Table through VBA. You can use below code to disable the filed selection
Code: 
pTbl.PivotFields("Mid  Part").EnableItemSelection = False

Please let me know whether it works or not. Here pTbl declared as Pivottable. And you can set it to activesheet.pivottables(1)
 
Vijay - Thanks for replying. Where would this code reside? And what does "Mid Part" refer to? Sorry if these questions are very basic... I'm relatively green when it comes to macros (I can record them and play around with them, but I don't have the bigger picture).
 
Dear Dronka

I have just used "Mid Part" for reference. Here Mid Part is the filed of the pivot table. As per your confirmation, you are not so familar with VBA, so if you upload your file, i will do it and upload it for you.
 
Thank you for this offer, Vijay. I'm exploring another avenue with my spreadsheet, so I may not go with this option. If I do, I may take you up on your offer! Thanks.

David
 
You must log in or register to reply here.
Back
Top