View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francisco Gomez Francisco Gomez is offline
external usenet poster
 
Posts: 2
Default 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?