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

    [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

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login