hi
see this site
http://cpearson.com/excel/vbe.aspx
make note of the warning.

Regards
FSt1

"Stephen sjw_ost" wrote:

I have a workbook that I need to copy a particular sheet out to save in a
separate workbook. This part is done and works.
The worksheet has an Activate piece that shows a user form. When I copy the
worksheet into its own workbook, programically, the code comes with it. When
the sheet is activated in the new workbook the code erros out because the
user form is not copied over with it, the userform is not needed in the new
workbook. How can I programically removed the Worksheet_Activate code when
the worksheet is programically copied out?

Thanks for any help
--
Stephen