Re: catch Excel Events

If the control is on a dialog box or CFormView, then you can bring up the
dialog template or the class then in the proprety window click the "Events"
icon (the one with the lighting bolt).
Expand the control for the sheet and scroll down to SheetCalculate event, in
the box to its left, click the drop down button and click add.
You should get something like this:

BEGIN_EVENTSINK_MAP(CExcelTestDlg, CDialog)

ON_EVENT(CExcelTestDlg, IDC_SPREADSHEET1, 1516, SheetCalculateSpreadsheet1,
VTS_DISPATCH)

END_EVENTSINK_MAP()

void CExcelTestDlg::SheetCalculateSpreadsheet1(LPDISPATCH Sh)

{

// TODO: Add your message handler code here

}

AliR.

"ooxoo" <ooxoo@discussions.microsoft.com> wrote in message
news:CDDE3AC8-9426-494C-8BE4-CE51E290A0F1@microsoft.com...