Determine if particular procedure(s) exist in module

X

XP

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...

Thanks much in advance.
 
H

Héctor Miguel

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...
Click to expand...

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.
 
Top