I want to open a user form where people go to grab information. Its used occasionally throughout the day many times. The problem is I want the userform to remain active and still allow the opening of other workbooks so they are not constantly opening the workbook everytime they want to use the form. If I use
it of course disables the use of any other workbook until the form is closed.userform1.show
I tried this to keep the form and its associated workbook open and still allow opening of other workbooks:
in the workbook open but it throws an error. Any ideas on how to solve this is appreciated.Call UserForm.Show(vbModeless)