Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application level events no longer execute
I have instituted a class module the way Chip Pearson suggests in order
to trap application level events. This works up until I run a macro that breaks in the middle. After I break, nothing short of quitting Excel will allow the class module (which is declared and run from an add-in and is not the file in which a function broke) to resume processing application level events. Not even setting the custom class to nothing and then re-creating it works. Ideally, I would like breaking a macro during execution to not affect the objects in other files. However, if this is not possible, I would at least like some way that is faster than restarting Excel to be able to start re-consuming application level events. Any help would be most appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application level events no longer execute
Not tested, but try:
Set App = Application from the Immediate Window. -- Vasant "R Avery" wrote in message ... I have instituted a class module the way Chip Pearson suggests in order to trap application level events. This works up until I run a macro that breaks in the middle. After I break, nothing short of quitting Excel will allow the class module (which is declared and run from an add-in and is not the file in which a function broke) to resume processing application level events. Not even setting the custom class to nothing and then re-creating it works. Ideally, I would like breaking a macro during execution to not affect the objects in other files. However, if this is not possible, I would at least like some way that is faster than restarting Excel to be able to start re-consuming application level events. Any help would be most appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
Using Application Events | Excel Programming | |||
tried to execute application from VBA | Excel Programming | |||
tried to execute application from VBA | Excel Programming | |||
tried to execute application from VBA | Excel Programming |