enable excel workbooks when userform is open

vba excel userform
Peter Mogford picture Peter Mogford · Dec 22, 2015 · Viewed 19k times · Source

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

mielk picture mielk · Dec 22, 2015

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

Call UserForm.Show(vbModeless)

Related questions

Passing variable from Form to Module in VBA

I have the following button on a Form: Private Sub CommandButton1_Click() Dim pass As String pass = UserForm1.TextBox1 Unload UserForm1 End Sub I then have a Module called Module1: Public Sub Login() ... UserForm1.Show driver.findElementByName("PASSWORD").SendKeys pass ... …

Read More
Excel VBA Open workbook, perform actions, save as, close

This question has been edited due to lengthy comments and updates from proposed answers. As requested here is module 13; Sub SaveInFormat() Application.DisplayAlerts = False Workbooks.Application.ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\jammil\Desktop\AutoFinance\ProjectControl\Data\" & Format(…

Read More
Calling UserForm_Initialize() in a Module

How can I call UserForm_Initialize() in a Module instead of the UserForm code object?

Read More