help in macro

[ali_hijazi]

Hello

I have a qvw document with one sheet this sheet contains several sheet charts

some of these charts are minimized by default

other are maximized

what I want is that when a user clicks a button all charts be minimized

but when the user clicks the button again the charts that were not minimized be resored

Please advise

[jonathandienst]

Hi

Add Layout | Minimize Object and Layout | Restore Object actions to your buttons. You can combine any number of actions for each button click.

On the buttons' Properties | Actions tab click Add and select the actions above. You can find the Object ID for each chart on the Properties  | General tab for each object.

Hope that helps

Jonathan

[Siva_Sankar]

Hi,  You can use the following macro code for minimizing... add macro        sub Minimize  ActiveDocument.GetSheetObject("CH03").Minimize  ActiveDocument.GetSheetObject("CH08").Minimize  ActiveDocument.GetSheetObject("CH09").Minimize  ActiveDocument.GetSheetObject("CH11").Minimize   .  .  .  .  .  .  ActiveDocument.GetSheetObject("CH20").Minimize  end sub    Similarly for maximize too...  Hope it helps..  Regards. Siva