The easiest way would be to use application level events in the
XLA. See http://www.cpearson.com/excel/AppEvent.htm for more
info.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ndalal" wrote in message
oups.com...
Hi,

I have an XLA add in which has menu item to insert new sheet.
This
sheet gets inserted to the XLS project. The code behind
inserting this
sheet resides in XLA, however I want to perform
"worksheet_change" kind
of function for this new sheet. I already have the code for
"worksheet_change" in XLA, but that does not help because the
new sheet
is part of XLS.

In order to do add "worksheet_change" for the new sheet
manipulation,
how do I "automatically" add the code into the new sheet from
XLA ??

I was thinking of inserting/copying the "worksheet_change" code
from
XLA to this newly generated sheet in XLS. But how? Any ideas,
clues?

Any help is appreciated.
Thanks in advance.

- Andy