Copy a part of worksheet with active x elements
When I tested it in xl2003, the controls from the control toolbox toolbar were
copied successfully.
Maybe you could try again--or even save, close, and reopen that new workbook.
Maybe it's a display problem that could be resolved by reopening the workbook.
dennis logan wrote:
Hello,
I write a sheet with some active-x elements that contains VBA Script and
want to copy a part of it to a new worksheet. I have tried with Method
"Worsheets.Copy" but only the lines and characters were copied, the active-x
objects were not.
I tried then to save the selected sheet as excel a template but found no
methods to insert this template as a new worksheet. Could any one suggest me
??
Thanks.
--
Dave Peterson
|