ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Determine if particular procedure(s) exist in module (https://www.excelbanter.com/excel-programming/417514-determine-if-particular-procedure-s-exist-module.html)

XP

Determine if particular procedure(s) exist in module
 
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éctor Miguel

Determine if particular procedure(s) exist in module
 
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.




All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com