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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"robotman" wrote in message oups.com...
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