N
ndalal
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
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