XLapp and Linking an addin ThisWorksheet to run multiple times

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top