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?

TIA EagleOne

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.

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.

hi, !

... I appreciate your thoughts, time and knowledge.

thanks for your feed-back (and...)

I just try to be a "mirror" of the knowledge from so many others :D

regards,
hector.