An easy way is to already have a worksheet  (perhaps
hidden) with the event  code you want. Copy that sheet
instead of adding  a new worksheet, and the
Worksheet_Change event code will be copied along with
the sheet. If you need to, copy any sheet witht eh
event logic you need, then select and clear/delete all
the cells on the sheet.

You also might find some help at the Erlandsen Data
Consulting site (lots of great vba  stuff there):

www.erlandsendata.no/english/index.php?t=envbavbe