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
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.