Some of the dashboards I build/use have a number of slicer controls which, while imminently useful, consume dashboard real estate. 

I'm hoping there is a way to embed the slicers in a form control, or have slicers dynamically visible / not visible base on the visible range in a worksheet (so that when a user scrolls, the slicer & time series controls "change" to be relevant to the tables / charts that have the focus). 

Hopefully that paints a picture of what I'm trying to achieve. Ideally I'd like users to be able to move the slicers out of the way (modal form) or have the appropriate slicers become visible, when specific rows are visible at top of a range.. 

Any advice welcome - vba and non vba solutions, freezing panes or other methods