Today’s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA. For more information about slicers, read PivotTable Slicers on Jan Karel’s website: http://www.jkp-ads.com/ . Juggling the SlicerCaches collection For each slicer you add to your workbook, Excel adds a SlicerCache object too, which controls which pivot table(s) your slicer controls. So suppose we have three sheets, Sheet1, Sheet2
Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/01/27/slicers-and-vba.aspx
Posted
Jan 27 2011, 01:59 PM
by
Microsoft Excel