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

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.

I try again to copy the sheet with active-x control to another new sheet and
then save, close and reopen it. It still doesn't work. Even when I create
template files and insert this to a new workbook, the template files would
not be copied.

Could it be a problem with the older excel version ?? I use still the old
version of Microsoft Excel 2000.



"Dave Peterson" wrote:

> 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
>

I don't think it's a problem with xl2k. I don't recall ever having a problem in
that version.

But I don't have any other guesses why you're having trouble.

dennis logan wrote:
>
> I try again to copy the sheet with active-x control to another new sheet and
> then save, close and reopen it. It still doesn't work. Even when I create
> template files and insert this to a new workbook, the template files would
> not be copied.
>
> Could it be a problem with the older excel version ?? I use still the old
> version of Microsoft Excel 2000.
>
> "Dave Peterson" wrote:
>
> > 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
> >

--

Dave Peterson