View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default another macro is running ... how to recognise that process in code

As far as I know only one VBA procedure can run at a time, so add-in1 should
not be running when your code (add-in2) runs.

That said, it doesn't always appear that way and crashes or hangs can be
tricky to avoid in these circumstances.

Tim

"Matthew Dodds" wrote in message
oups.com...
Thanks Madhan, I haven't come across the autolist feature, and F1
offers no help; how do I go about using it?
Thanks

Matthew




On 18 Apr, 16:44, Madhan wrote:
Hi, in my opinion, any AddIn will expose its methods and properties. You
should try using the autolist feature of VBA to find out its methods,
which
might help you in understanding how it works.



"Matthew Dodds" wrote:
I have written an AddIn (call it AddIn_2) which picks up where another
(AddIn_1) leaves off.


AddIn_2 uses events to identify when a particular worksheet is
activated to enable a menu item.


AddIn_1 creates that worksheet and reiteratively activates it during
its process ... causing a messy crash. AddIn_1 is a commercial product
and I have no access to its code.


I want to be able to write a clause like
if AddIn_1 is running


end if- Hide quoted text -


- Show quoted text -