I followed the example in VBA2000, Chapter 13, pages 227-228 for enabling Application Event trapping from an Add-in. The first part seems to work, but creating the instance of my class module and assigning the Application object fails with this error message:

"User-defined type not defined" in the line
Public xlApplication As New clsAppEvents

I am using Excel 2002 on XP SP2.

I found a very similar example in VBA Help and it fails with the same message. This code is in a regular module as instructed.

Any help would be greatly appreciated.

Thanks,

Terry

Answering my own question...

I found the correct code to do this here:
http://www.cpearson.com/excel/AppEvent.htm

Both VBA Help and VBA2000 have incorrect code examples.

This let's you get events from all open workbooks which is good for an .xla.