enable excel workbooks when userform is open

Question

I have a workbook that opens a user-form when the workbook is opened. This has caused a problem because it then disables all open excel workbooks so users cant make changes to other workbooks

Is there a way i can let users still edit/open other open workbooks and still keep the user-form open?

Thanks in advance

Answer 1

You need to open user form with Modal parameter set to vbModeless:

Call UserForm.Show(vbModeless)

Answer 2

On the properties of the user form change ShowModal to false.