hi

I have a procedure that adds a new sheet, names it, formats it, inserts
formulas, etc. I have one more thing to do to the new sheet, but its giving
me trouble. I need to add code to the new sheet's Worksheet_Change event.
How do I go about doing this? The code is already written, I just don't
know how to 'insert' it into this event.

Thanks
Bri

Hi Bri,

have a look at:

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

Regards,
Ivan

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

--
Regards,
Tom Ogilvy


"Bri" wrote:

hi

I have a procedure that adds a new sheet, names it, formats it, inserts
formulas, etc. I have one more thing to do to the new sheet, but its giving
me trouble. I need to add code to the new sheet's Worksheet_Change event.
How do I go about doing this? The code is already written, I just don't
know how to 'insert' it into this event.

Thanks
Bri

exactly what I needed. Much thanks to both
Bri

"Tom Ogilvy" wrote in message
...
http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Bri" wrote:

hi

I have a procedure that adds a new sheet, names it, formats it, inserts
formulas, etc. I have one more thing to do to the new sheet, but its
giving
me trouble. I need to add code to the new sheet's Worksheet_Change event.
How do I go about doing this? The code is already written, I just don't
know how to 'insert' it into this event.

Thanks
Bri