View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default 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?