Make slicer selection via Userform upon worksheet opening.

emarold

New Member
Joined
Mar 3, 2013
Messages
3
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.
 

Forum statistics

Threads
1,082,610
Messages
5,366,601
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top