Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to handle 'sheetchange' event on 'add-in'
Hello,
I hope to know how can I handle the sheetchange event on my add-in xla program? you know, If I create add-in, It's not part of what I working project. So, I can't handle the event. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to handle 'sheetchange' event on 'add-in'
Hi Takoyaki,
You could create application events in your add-in, and test for applicable workbooks. In the add-in ThisWorkbook module add, Private Sub Workbook_Open() Dim AppClass As clsAppEvents Set AppClass = New clsAppEvents Set AppClass.App = Application End Sub also create a class, call it clsAppEvents, add this line Public WithEvents App As Application then run the Workbook_Open code, and in the class dropdown, you will se App as an object, and then you can select the SheetChange event. -- HTH RP (remove nothere from the email address if mailing direct) "Takoyaki" wrote in message ... Hello, I hope to know how can I handle the sheetchange event on my add-in xla program? you know, If I create add-in, It's not part of what I working project. So, I can't handle the event. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to handle 'sheetchange' event on 'add-in'
Thanks Bob!!
I'm really thank you ! "Bob Phillips" wrote in message ... Hi Takoyaki, You could create application events in your add-in, and test for applicable workbooks. In the add-in ThisWorkbook module add, Private Sub Workbook_Open() Dim AppClass As clsAppEvents Set AppClass = New clsAppEvents Set AppClass.App = Application End Sub also create a class, call it clsAppEvents, add this line Public WithEvents App As Application then run the Workbook_Open code, and in the class dropdown, you will se App as an object, and then you can select the SheetChange event. -- HTH RP (remove nothere from the email address if mailing direct) "Takoyaki" wrote in message ... Hello, I hope to know how can I handle the sheetchange event on my add-in xla program? you know, If I create add-in, It's not part of what I working project. So, I can't handle the event. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SheetChange Event | Excel Programming | |||
SheetChange Event | Excel Programming | |||
sheetChange event and list validation | Excel Programming | |||
SheetChange event starts before .calculate finished | Excel Programming | |||
SheetChange event starts before .calculate finished | Excel Programming |