Write code to a new worksheet?

[robotman]

I have a macro that creates a new worksheet.

One of the functions on this new worksheet is to detect changes in
itself and then respond accordingly using the Worksheet_Change
methodology.

Is there a way to write code via another macro to the new worksheet so
I can build the Worksheet_Change routine in the newly created
worksheet?

Thanks.

John

 

[Ron de Bruin]

You can create a sheet template(with the code) and insert that sheet with code or
See Chip Pearson's site
http://www.cpearson.com/excel/vbe.htm