how to copy option button from one worksheet to another
 

Hi,

I design some templates in one worksheet in Excel. In each template, it
includes many option buttons(From ActiveX control) and some text
contents. According to different requirements, I want to copy specific
template to another worksheet. I write the following VBA code, however,
only text content of the template range is pasted into another
worksheet. I want to know how can I copy the option buttons in the
template into another worksheet as well. Do you have some ideas about
this issue? Thank you in advance!!!

VBA code:
Worksheets("templateworksheet").Range("D25:E25").C opy
Destination:=Worksheets("newworksheet").Range("E10 ")


Best Regards

Sam