Refer to a control inserted in chart
I have inserted a checkBox in a chart. I need to refer to it programatically,
buy I must not use the control's name, because I plan to copy-paste the sheet
(chart is embedde on it) many times, and control (two checkboxes and one
command button) names change.
I have tried to search it by type (an later by 'caption' -it doesnt change
through copy-paste), in OLEObjects collection
For each obj in ActiveChart.OLEObjects
But ActiveCharts.OLEObjects is an empty collection for me.
Can you help me with this problem?
|