Determine if particular procedure(s) exist in module

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determine if .ldb file exist	=?Utf-8?B?bGpy?=	Microsoft Access VBA Modules	1	9th Aug 2007 01:21 AM
How to jump from a Form procedure to a Workbook or Module procedure?	T. Erkson	Microsoft Excel Programming	4	25th Jan 2007 07:15 PM
In a query, which function can determine if a field is exist or no	=?Utf-8?B?TWFkZWxlaW5lUA==?=	Microsoft Access Queries	5	7th Oct 2005 07:27 PM
Determine if ValidationSummary exist in a page	John Shum	Microsoft C# .NET	0	5th May 2005 03:29 AM
Determine if a file exist	Tony	Microsoft Access External Data	4	15th Feb 2004 03:52 PM