hi, !

Using Office 2007 on Win XP;
Can someone please post an example function that determines if a particular Procedure exists in the "ThisWorkbook" module or not?
Specifically, Workbook_Activate and/or Workbook_Deactivate...

you could start looking at:

Programming The VBA Editor: http://www.cpearson.com/Excel/vbe.aspx
seek in last quarter of page for: "Searching For Text In A Module"

hth,
hector.