I have a dashboard with several sheets displaying charts in various levels of drill down. While the sheets at the global level are very clear and easy to read, the sheets at the manager level are extremely busy until a Manager is selected in the slicer.
Is there a way to have a userform pop up when the Manager sheet is selected forcing the selection of a manager (or multiple managers) in the slicer? I want more than just an instructional popup. I would like them to actually select a manager either from a drop down list or via selection or radio buttons. In either case, the selection should automatically affect the slicer thereby changing all the charts.
Is this possible or am I asking too much. Sadly I have managers that need to be spoon fed.
Is there a way to have a userform pop up when the Manager sheet is selected forcing the selection of a manager (or multiple managers) in the slicer? I want more than just an instructional popup. I would like them to actually select a manager either from a drop down list or via selection or radio buttons. In either case, the selection should automatically affect the slicer thereby changing all the charts.
Is this possible or am I asking too much. Sadly I have managers that need to be spoon fed.
