Minimizing several objects with a button

[oxiofrt]

Hi,

Actions related to button are really useful. I use them to restore / minimize some of my charts.
Is it possible to specify to restore or minimize several objects within the same action ? How ?

I would like to avoid the use of variables.
Thanks a lot for your help !

[#2 · Accepted solution]

Hi

The following macro minimizes all objects on the active sheet.

sub MinimizeAll
Objects = ActiveDocument.ActiveSheet.GetSheetObjects
For j = lBound(Objects) To uBound(Objects)
set obj = Objects(j)
obj.Minimize
next
end sub

/Fredrik

[oxiofrt]

Thanks a lot for your answer.
I can do it with acros but I would like to avoid using them. New actions available in QV9 often can replace them.

Something cool would have been to have the ability to specify several Objects ID in the action (as shown in the screen capture herefater).
Thanks , bye

[#4]

Hi,

For button you can define more than one action, so why don't you try to add one action to minimize for each object you have in sheet?

Andris

[oxiofrt]

Thanks for your answer.

That is the way I proceed for the moment.

But I am not satisfied with it, because as soon as I have more than 5 objects to minimize, it would be really more useful to specify all of them into only one action

Mr. Qlikview, if you hear me :
- please add a possibility to find objects ID directly from the action form
- please add a list of values inside the formula assistant