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

            Hi,

            Go to tools---> Edit module

            Copy this piece of code

             

             

            Sub ShowPremium

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

            cs.Minimize

            set cs = ActiveDocument.GetSheetObject("CH74")

            cs.Minimize

            set cs = ActiveDocument.GetSheetObject("CH66")

            cs.Restore

            set cs = ActiveDocument.GetSheetObject("CH67")

            cs.Restore

            set cs = ActiveDocument.GetSheetObject("CH68")

            cs.Restore

            set cs = ActiveDocument.GetSheetObject("CH69")

            cs.Restore

            End Sub



             

             

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

             

            Hope this helps,

            Sam