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
MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
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