This topic has not yet been rated - Rate this topic

Handling Events

Office 2013

Published: July 16, 2012

Starting in Excel 2010, XLLs can receive events designed to manage the asynchronous function life cycle. The events are as follows:

CalculationEnded : Raised when Excel is finished calculating. After this event, you can free resources allocated during the calculation.
CalculationCanceled : Raised when the user interrupts the calculation. The XLL stops any asynchronous activities. Immediately following this event, the CalculationEnded event is raised.

To handle these events, the XLL uses the C API function xlEventRegister.

Note
CalculationEnded and CalculationCanceled are not raised during programmatic recalculation.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)