2 Replies Latest reply on Sep 9, 2015 8:24 AM by Manjiri Virkar

    Hiding Quick Filters Dynamically upon sheet selection

    Prem Reddy

      Hi All,

       

      I'm trying to hide sheets based upon selection in the parameter which I'm even able to achieve it but the problem is that the quick filters of specific sheets cannot be hidden. Is there any workaround to achieve it so that even quick filters of sheets disappears along with the sheets. For e.g. in my attached workbook upon selecting any of the chart type the quick filters of the other sheet are still available which leads to ambiguity for the users to understand filters pertaining to sheets.

       

      Regards,

      Prem