View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dennis logan[_2_] dennis logan[_2_] is offline
external usenet poster
 
Posts: 8
Default Copy a part of worksheet with active x elements

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.