I have an adding which includes adding a new workbook. One of the guys using
my addin gets stuck as the adding of a new workbook causes Excel to launch a
modal dialog via another addin he has installed. How can I trap this, and how
can i talk to this other dialog to close it?

Any help appreciated

regards

ojv

Have you tried using
Application.EnableEvents = False
in your code to prevent his other addin from triggering? Just be sure to
reenable them when you're done.
Application.EnableEvents = True
--
Charles Chickering

"A good example is twice the value of good advice."


"ojv" wrote:

> I have an adding which includes adding a new workbook. One of the guys using
> my addin gets stuck as the adding of a new workbook causes Excel to launch a
> modal dialog via another addin he has installed. How can I trap this, and how
> can i talk to this other dialog to close it?
>
> Any help appreciated
>
> regards
>
> ojv

No, not yet, but I sure will. Thx for taking the time.

ojv

"Charles Chickering" wrote:

> Have you tried using
> Application.EnableEvents = False
> in your code to prevent his other addin from triggering? Just be sure to
> reenable them when you're done.
> Application.EnableEvents = True
> --
> Charles Chickering
>
> "A good example is twice the value of good advice."
>
>
> "ojv" wrote:
>
> > I have an adding which includes adding a new workbook. One of the guys using
> > my addin gets stuck as the adding of a new workbook causes Excel to launch a
> > modal dialog via another addin he has installed. How can I trap this, and how
> > can i talk to this other dialog to close it?
> >
> > Any help appreciated
> >
> > regards
> >
> > ojv