loop through charts using macro

[ali_hijazi]

hello

I'm using QlikView 11.2

I want to loop through all available charts of the active sheet

I'm writing the following macro

Sub GetCharts

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

For i = lBound(Objects) To uBound(Objects)

If obj.GetObjectType = 11  Then

msgbox("Chart: " & obj.GetObjectId)

End If

next

End Sub

however when I call this macro from a button the Edit Module opens and nothing happens

please advise

[Gysbert_Wassenaar]

See this discussion for some example code that loops through sheet objects: Re: Load help text of objects