6
votes

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

2

2 Answers

10
votes

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

Call UserForm.Show(vbModeless)
8
votes

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