Chip Pearson has some stuff you'll want to read:
http://www.cpearson.com/excel/vbe.htm

Dennis Hancy wrote:

I think I have a similar situation.

In part of my VBA, I create a new worksheet using the code:

worksheets.add.move befo=Worksheets(1)

What I need to do is add code to the Worksheet_Change event.

Natually I can add this "manually" after the fact, but I'd like to add
this code to the new worksheet as soon as it's created.

Can this be done?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH

<<snipped
--

Dave Peterson