Table box hide base on another table box

[ivandrago]

Hi,

I have 6 different charts on one tab, 2 of them are a table box which i use for detail. When I double click on one of them the current chart will minimize and the new one will appearing in the same location. For the two table box I want them to be excluded from the other 4 graphs, so when I double click on one them I want it to appear on a different location on the page but I do not want the graph to hide, the graph should only hide when the other 4 are clicked.

Thanks

[vgutkovsky]

Ivan,

This is a very popular request, but is not possible with QV 8 or 9. You can only have 1 autominimize group per sheet. I think QV 10 allows multiple groups so you can define which objects should be group together for minimization. For now, you will need to design around this limitation.

Regards,

[ivandrago]

Do you think a macro would work so it would hide and unhide the table? If so would you know what the code would be for this?

Thanks

[vgutkovsky]

Sure, you can do this with a macro and then set a button to execute the macro. Check the API guide for more details, but I think the API you want is ActiveDocument.GetSheetObject("ID").Minimize

Regards,

[ivandrago]

Would you be able to provide a example qvw that does this?

[vgutkovsky · Accepted solution]

There are different ways of doing this, but 1 example is attached.

Regards,

[ivandrago]

Thanks! Nice work!