Is it possible to catch Excel's Workbook events?

Feb 25, 2010 at 3:29 PM

Hello,

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

thanks

Great Project...

Armin

Coordinator
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: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.sdk&tid=3bffd8ab-fb88-4869-b1f9-ebf0736e16f5&cat=en_us_7f5f1c8f-b90c-4500-9751-5fe12a45b0e1&lang=en&cr=us&sloc=&p=1

Regardsm

Govert

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