Setting selected item in a slicer connected to a Power Pivot table via VBA

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Yesterday a colleague asked me whether it was possible to select an item in a slicer via VBA and I replied "Of course" - but that was before I studied the documentation about the "Selected" property of the SlicerItem object - "Returns or sets whether the slicer item is selected. Read/write for slicers connected to non-OLAP data sources. Read-only for slicers connected to OLAP data sources."

Read more...

Tags: excel, slicer, vba

 

2007-2015 VidasSoft Systems Inc.