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

  • 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

    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

  • A modal dialog would already have that effect (that's what modal means).

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • 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

  • I don't know anything about pyxll so can't help you with that, I'm afraid.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • In VBA userforms have a ShowModal property, and you can also specify whether to show them modally or not with the Show method, but I don't know whether that will help you at all.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why