Hector, I appreciate your thoughts, time and knowledge.


Héctor Miguel" wrote:

hi, !

2003, 2007 Assume: a VBA project VBAProject(Test) is listed in IDE
What VBA code line would "sense" (True/False) if and attempt to open VBAProject(Test) is requested?
And/Or if VBAProject(Test) is open in an IDE window?
And/Or if the IDE is open?

I don't think that vba-code could "sense" if (another) vba-code attempts to enter in a vba-project (???)

you can find what (and how) to do in the vbe-ide through code starting from this page:
(Chip Pearson): Programming The VBA Editor: http://www.cpearson.com/Excel/vbe.aspx

if you need to catch when somebody tries to profanate your macros...
you should use/back to the (ancient ?) xl4 macro-functions programming language

regards,
hector.