Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Monitoring application-level event problem
I am working on a project, and for inspiration I am using Walkenbach's
utility (from Excel 2002 power programming with VBA)... I have dumped all of the code to a .XLA, which i load. It works perfectly, except when I run other macros (e.g., from my Personal.xls) and use CTRL-Break to stop the macro. After that point, even though the XL object still exists, and it works normally (tested using the immediate window), no application-level events work. This occurs even if I set XL = nothing and then set it back to the excel.application or thisworkbook.parent. Does interrupting a macro (and then ending it) do something to the current Excel instance which prevents all future events from firing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch Click Event Using Application.Run | Excel Discussion (Misc queries) | |||
captcure close application event | Excel Worksheet Functions | |||
Application level event help | Excel Discussion (Misc queries) | |||
Turn off Reviewing options at the application level | Excel Discussion (Misc queries) | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |