Show object when container object is active

[varunvarma]

Hello All,

Please provide solution for below scenario.

In my sheet, i have one container object and one list box object. In container object, i have two chart objects (CH01 and CH02). Now i want to show list box when chart 2 (CH02) is selected in container object else that list box should hide until that CH02 is selected. Please let me know. Thank you.  

[varunvarma]

Hello All,

Any solution for above requirement. Thank u.

[tresesco]

Only macro can help. See: How to identify which Object ID is active inside a container

[varunvarma]

Thank you.