View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mikehoar@geocomp.fsnet.co.uk is offline
external usenet poster
 
Posts: 2
Default 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.