2 Replies Latest reply: May 24, 2013 2:48 AM by Mubbasher Khaliq RSS

    How to make same filter single select on one sheet and multi select on another sheet

      Hi everyone ,

       

           I have a filter "Year" on two sheets , I want to make it multiselect on one sheet where as single select on other sheets , I have written these macros which I am running over sheet activation , "makeYearSingle" where I want to make year single select and "makeYearMultipleSelect" where I want to make it multiselect , but they are not working , can anyone address the problem ???

       

       

       

      Sub makeYearSingle

                set sheet=ActiveDocument.ActiveSheet

                set objProperties=sheet.GetSheetObject("LB19").GetProperties

                objProperties.AlwaysOneSelectedValue=true

      End Sub

       

       

      Sub makeYearMultipleSelect

                set sheet=ActiveDocument.ActiveSheet

                set objProperties=sheet.GetSheetObject("LB11").GetProperties

                objProperties.AlwaysOneSelectedValue=false

      End Sub