Removing VBA routines

[Robin Clay]

Greetings !

I wish to copy a worksheet into a new WorkBook, but in the
new copy I don't need the

Private Sub Worksheet_Change(ByVal Target As Range)....

that exists in the "original"

What code do I need to insert into the copying routine to
delete that code from the copied sheet ?

 

[Ron de Bruin]

See Chip's site for a example
http://www.cpearson.com/excel/vbe.htm

 

[Tom Ogilvy]

See Chip Pearson's site on working with code using code

http://www.cpearson.com/excel/vbe.htm