question

VibhorGupta-2502 avatar image
0 Votes"
VibhorGupta-2502 asked emilyhua-msft edited

How to freeze/disable excel when a modal box is open ???

Hii,

I am working on a excel addin app . This app is using pyxll addin and python to create the functions for excel. Now I have a gui package which generate a gui box in python running on the same thread of excel. Due to which the main thread of excel get blocked. Now the problem is when I am working on the gui form box which is very similar to modal box the excel stays available in background for modification which creates a problem since the excel thread is blocked. so what I need is something with which I can make excel not available/freezed/disabled when the gui form box is open. any vba or any language solutions is acceptable

Again I understand I have a uneven question but I cannot find a suitable place where I can get a answer for this question.

So any guidance will be very supportive

office-vba-devoffice-addins-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@VibhorGupta-2502

According to your description, your issue is more related to the code, I would remove the tag "office-excel-itpro", due to we are more concerned about general issues of Excel client, and I would add other tags related to Office development.
Thanks for your understanding.

To better help you, it is also recommended to post a new thread on the developer forum. You could refer to "Ask questions" under the resources section.
Excel add-ins documentation

0 Votes 0 ·

0 Answers