Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLapp and Linking an addin ThisWorksheet to run multiple times
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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting multiple times against one date succesively for multiple | Charts and Charting in Excel | |||
linking multiple columns onto multiple worksheets | Excel Discussion (Misc queries) | |||
XLapp.Workbooks.Open is not opening XL app but path is correct | Excel Discussion (Misc queries) | |||
How do I add multiple times together | Excel Discussion (Misc queries) | |||
XLapp and SheetChange | Excel Programming |