2 Replies Latest reply: Aug 31, 2010 5:40 AM by ssamanta RSS

    Create a button to minimize and maximise graphs

      I am after a button that will minimise the graphs that are not applicable and will maximise the graphs which are applicable.

        • Create a button to minimize and maximise graphs
          Or Shoham

          This is normally achieved by using a variable. Your button(s) will change the variable's value. In each graph's 'Show'/Conditional (under the Layout tab in object properties), use a condition along the lines of myVariable = X. Your variable might start off at 0, with buttons to change it to 1, 2, or 3 - each showing a different group of objects with myVariable = 1, myVariable = 2, or myVariable = 3 in their 'Show' box

          Good luck.

          • Create a button to minimize and maximise graphs


            Go to tools---> Edit module

            Copy this piece of code



            Sub ShowPremium

            set cs = ActiveDocument.GetSheetObject("CH73") // object id is put inside the braces


            set cs = ActiveDocument.GetSheetObject("CH74")


            set cs = ActiveDocument.GetSheetObject("CH66")


            set cs = ActiveDocument.GetSheetObject("CH67")


            set cs = ActiveDocument.GetSheetObject("CH68")


            set cs = ActiveDocument.GetSheetObject("CH69")


            End Sub



            Create a button object and in the macro , give macro name as ShowPremium


            Hope this helps,