How can i know a active object inside a conteiner?

[ericoaleixoin]

Hy folks,

I have a conteiner with 3 charts, i need to know which chart is active!

Someone could help me?

tks a lot!!!

[#2]

Create a variable vActiveChartID.

Then go to sheet properties->Triggers->Sheet Object Event Triggers. On active of chart 1 set vActiveChartID to 1 and so on for the other three charts.

This variable is now the tracker of active chart in the container.

Hope this helps,

Kiran

[ericoaleixoin]

Kiram,

I understood your idea, but my charts are inside the conteiner object, and Triggers attend just a conteiner and not a charts inside the conteiner.

Thanks for idea!!!

[#4]

Yes, just realised that. As a workaround, you can replace container with textboxes and conditional show on the charts.

Kiran.