cloning worksheet

[vientito]

Hi just a quick question

if I clone (copy) and create another worksheet alongside the original sheet, how does it affect the names of my dynamic tables and activeX control objects for the new ones?

For example I have 5 dynames tables named as A_table1, A_table2, A_table3, A_table4, A_table5 and 2 activeX comboboxes called B_CB1,B_CB2 on sheet1,
will the cloned sheet now come with B_CB12, B_CB22 and another set of global scoped dynamic tables A_table12,A_table22, A_table32, A_table42, A_table52 ?

What convention does Excel follow to give to this new objects?

[LJMetzger]

Hi vientito,

They should have the same names, and you should probably reference them with the sheet when you try to access them. When creating an Active X object I always use something like:

Please Login or Register  to view this content.

and when using an existing Active X object I use code like:

Please Login or Register  to view this content.

I hope this helps.

Lewis