Macro Maximize and Minimize Object

[Anonymous]

Hi experts,

I did two buttons that have a macro with the following code:

However, as the code is not optimized, when I double click on the button 1, it minimizes the graph referring to it and shows the graphic for the button 2.

It is easy to see that this is because there is nothing in the code that do: "If the chart is maximized, keep maximized until another button is clicked."

Someone who understands VBscript can help me in this code?

Thank you

[shree909]

Instead of using macros , why dont you use auto minimize option on the charts.

First ,

1. Create  the different charts and check the below  options marked in red.
2. allign all the minimized charts on left hand side.
3. whenever a chart is selected, it will expand,  on selection of other chart the first one will minimize automatically.
4. the only limitation it has, only one chart is displayed once.

[tamilarasu · Accepted solution]

Hi Alex,

In this case, you can use conditional show and hide option. I have attached a sample file for your understanding.