
New Member

August 10, 2018

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


July 16, 2010

Hi Justin,
Welcome to our forum! Given how long this thread has taken to get a response you've probably realised the answer is that you can't do this easily.
I'll move this thread to the VBA forum as this will be the only way it's possible. Hopefully someone there will have some ideas.
Mynda
1 Guest(s)
