Posts by vibhorpgupta

sure let me see if I can use this thank you for your help

well if we have such a case in excel vba also then how can we do it is there any way

Hii rory you are correct but the problem is my gui box is not a modal box due to which I cannot get this effect . is there any way we can get this effect when needed manually

[xpost][/xpost]

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