Open UserForm as New instance/Make other work editable when userForm is open

  • Dear all,
    When userForm is open, other workbooks usually hang-up. We cannot select any data for other workbooks until we close userform.
    Is it possible to open userform as new instance.?
    My basic intent is to make other workbooks editable when userForm is open.



    Thanks
    madvesh

  • Re: Open UserForm as New instance/Make other work editable when userForm is open


    Set its ShowModal property to False.

    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

  • Re: Open UserForm as New instance/Make other work editable when userForm is open


    You're welcome.


    In future, please read the forum rules on cross-posting and add links as required.

    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!