View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Mark Worthington Mark Worthington is offline
external usenet poster
 
Posts: 24
Default VBE code pane

Mark,

I wouldn't trust the ActiveCodePane or ActiveVBProject to be the
same as the currently running procedure.


Chip,

I see what you mean when I test my error handler in VBE. As I step
through, the windows change as another module is accessed, and the
module name (given by
Application.VBE.ActiveCodePane.CodeModule.Parent.N ame) is incorrect.

Seems to work in the "real" world, but of cours my applications are
simple & local.

Ta for the help,

Mark