Is it possible to catch Excel's Workbook events?

Feb 25, 2010 at 3:29 PM


is it possible to add an callback method for the workbooks base events or sheet events?


Great Project...


Mar 3, 2010 at 9:22 AM

Hi Armin,

There are two ways to deal with the Excel events - one is through the native interface - youd call XlCall.Excel(xlcOnWindow, "MyOnWindowMacro) etc.. However, only a limited set of events are supported.

The other is to hook up the events as you'd do in VBA, starting with the ExcelDnaUtil.Application object. This might be more dangerous when mixed into an .xll, so you need to experiment a bit and take care.

This thread seemed to have some nice information:



Mar 3, 2010 at 9:52 AM

Hi Govert,

thanks for answer

I will write an excel addin thats have a dialog with input field same as original chart wizard.

In this wizard you mark a range on sheet and the input field on wizard is capturing your selection.

So similar i want capturing the selection of user.

Have you a solution for this?

to greet Armin