Hi
In the attached workbook, I have made an easy excample of what I'm trying to solve.
I have a front page with shapes that will control the slicers in the other page. So if I press "USA", or "CA", it will choose that shape's name (or caption) in the slicer/filter value.
The table is in the datamodel, and only as an "connection".
I believe the country shapes need one macro, and the state-shapes a different macro, since it is two different slicers.
I have tried so many VBA versions, without luck.
Can someone try to make this work, thanks?
Bookmarks