Macro to work on 2 container objects

[helen_pip]

Dear Qlikview user

I have copied a macro which changes the tabs on a container

I now have 2 containers with the exact same number of tabs, and wish for the macro to apply to both containers

Can anyone help me with how I can amend the macro code so that it incorporates the object "Container Graph" also

Sub ActivateTab(I)

  Set Obj=ActiveDocument.GetSheetObject("Container Table")

  Set ObjProp=Obj.GetProperties

  ObjProp.SingleObjectActiveIndex=I

  Obj.SetProperties ObjProp

end Sub

Sub ActivateTab0()

  ActivateTab(0)

end Sub 

Sub ActivateTab1()

  ActivateTab(1)

end Sub 

Sub ActivateTab2()

  ActivateTab(2)

end Sub

Sub ActivateTab3()

  ActivateTab(3)

end Sub

Sub ActivateTab4()

  ActivateTab(4)

end Sub

Sub ActivateTab5()

  ActivateTab(5)

end Sub 

Kind Regards

Helen

[marcus_sommer · Accepted solution]

Maybe with:

Sub ActivateTab(I)

for j = 1 to 2

  Set Obj=ActiveDocument.GetSheetObject("Container Table_" & j)

  Set ObjProp=Obj.GetProperties

  ObjProp.SingleObjectActiveIndex=I

  Obj.SetProperties ObjProp

next

end Sub

- Marcus

[helen_pip]

Hello Marcus

Thank you very much

This works for me

Kind Regards

Helen