Microsoft Excel - Event listener in MS Excel

Hi,

I'm trying to set up an event listener in Excel that will trigger when the calculation mode is changed.

In a class module, I've declared Private WithEvents XLApp As Application and initialize it using Set XLApp = Application.

From here I can set up events that look out for new workbooks opening etc, but can't see where the calculation method is.

Is there anyway to look out for a change in calculation from manual to auto?

Cheers

Pete

When using events and listeners:

• Only handle classes can define events and listeners (See Naming Events for syntax).

• Call the handle notify method to trigger the event (See Triggering Events, and Defining and Triggering an Event, for examples). The event notification broadcasts the named event to all listeners registered for this event.

• Use the handle addlistener method to associate a listener with an object that will be the source of the event (Listening to Events, Creating a Listener for the Overflow Event, and Creating a Listener for the Property Event).

• When adding a listener, pass a function handle for the listener callback function using a syntax such as the following:

  • addlistener(eventObject,'EventName',@functionName) — for an ordinary function.

  • addlistener(eventObject,'EventName',@Obj.methodName) — for a method of Obj.

  • addlistener(eventObject,'EventName',@ClassName.methodName) — for a static method of the class ClassName.

• Listener callback functions must define at least two input arguments — the event source object handle and the event data (See Defining Listener Callback Functions for more information).

• You can modify the data passed to each listener callback by subclassing the event.EventData class (See Defining Event-Specific Data) and Defining the Event Data for more information).