ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Addin interference (https://www.excelbanter.com/excel-programming/401219-addin-interference.html)

ojv[_2_]

Addin interference
 
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

Charles Chickering

Addin interference
 
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


ojv[_2_]

Addin interference
 
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



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

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