Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Event Scope Problem
I have an Add-In where I have created a class which holds a couple of
application level events. In the class I declare a public Application object WithEvents. The class is instantiated in the Add-In WorkBook_Open event. When I load a workbook with the Add-In attached the events seem to fire ok on the workbook, it being the active workbook. However, I have a form on the Add-In activated from a toolbar button which is periodically displayed during a program loop for the user to make a choice. On the form I have a button which stops the program with the End keyword if the user wants to stop the program. When this button is pressed the code stops running ok but so do the application events. Any help appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch Click Event Using Application.Run | Excel Discussion (Misc queries) | |||
Application level event help | Excel Discussion (Misc queries) | |||
Problem in Variable Scope | Excel Programming | |||
Generic questions about variable scope the Initialize event | Excel Programming | |||
Monitoring application-level event problem | Excel Programming |