Determine if particular procedure(s) exist in module

  • Thread starter Thread starter XP
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dueling events 1
Share global variable between workbooks 2
Prevent "Add-Ins" from appearing in Ribbon 1
Macro appears 5 times 3
Determine if Sub Exists 4
Excel Add-In to catch application events 1
Calls from sheet module to ThisWorkbook module 2
Identifying Machine or Location When a Procedure is Run 6

Back
Top