S
strataguru
Hi,
I have a number of macros that I have embedded in my addin in the
ThisWorksheet of the addin.
A few of the macros inside ThisWorksheet monitor the SheetChange with
the XLapp functionality.
So - when my workbook opens - the XLapp is pulled in:
Private Sub Workbook_Open()
Set XLapp = Application
End Sub
This works fine on the first execution of any macro.... for example - a
macro that updates a few cells - which then invokes the
XLapp_SheetChange - which causes a few cells to update.
The next time I try running a macro - the XLapp_SheetChange doesn't get
kicked off. It's like the link between the addin and my workbook has
been disconnected.
I even tried manually putting the statement:
Set XLapp = Application
at the tail of my macro in ThisWorkbook - but that doesn't help.
Any ideas?
Thanks,
Robin
I have a number of macros that I have embedded in my addin in the
ThisWorksheet of the addin.
A few of the macros inside ThisWorksheet monitor the SheetChange with
the XLapp functionality.
So - when my workbook opens - the XLapp is pulled in:
Private Sub Workbook_Open()
Set XLapp = Application
End Sub
This works fine on the first execution of any macro.... for example - a
macro that updates a few cells - which then invokes the
XLapp_SheetChange - which causes a few cells to update.
The next time I try running a macro - the XLapp_SheetChange doesn't get
kicked off. It's like the link between the addin and my workbook has
been disconnected.
I even tried manually putting the statement:
Set XLapp = Application
at the tail of my macro in ThisWorkbook - but that doesn't help.
Any ideas?
Thanks,
Robin