ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting Excel Ready property (https://www.excelbanter.com/excel-programming/366732-setting-excel-ready-property.html)

Dermot Hardy

Setting Excel Ready property
 
Hi,

I have an Excel add-in which can be used to bring up some custom dialogs. I
know that Excel sets the Application.Ready property to False while its own
dialogs are being displayed, and I would like to have my add-in also set the
property to False when the custom dialogs are displayed.

Does anyone know how this might be achieved?

Thanks in advance,
Dermot



Dermot Hardy

Setting Excel Ready property
 
Thanks Gary but my forms are Modal. The Excel add-in itself works fine. My
problem is with another party's application which makes use of Excel's
Application.Ready property to decide if it can make automation calls into
Excel. This other application correctly handles one of Excel's dialogs
being displayed, but it does not behave so well when one of my custom
dialogs is displayed (because it assumes that Excel is ready when it is
not).

Thanks,
Dermot


"Gary Brown" wrote in
message ...
Sounds like you want to make your forms Modal.
MyForm.ShowModal = true

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of
the
post.



"Dermot Hardy" wrote:

Hi,

I have an Excel add-in which can be used to bring up some custom dialogs.
I
know that Excel sets the Application.Ready property to False while its
own
dialogs are being displayed, and I would like to have my add-in also set
the
property to False when the custom dialogs are displayed.

Does anyone know how this might be achieved?

Thanks in advance,
Dermot







All times are GMT +1. The time now is 05:21 AM.

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