title: How to open a file from a userform and modify it with the userform open
body: <p>I have a userform with checkboxes, textfields and the normal usual things on it, including a button that I'd like to use to open a excel spredsheet. This is easy enough to do:</p>
  
  <pre><code>Private Sub CMB2_Click()
      Workbooks.Open Filename:="G:\Formular.xlsm"
  End Sub
  </code></pre>
  
  <p>When doing this though, the file can not be worked on; in other words, it is not active. The from is active, and until the form is closed or cancelled, the file is locked. I call it locked for a lack of a better description.</p>
  
  <p>If I make the form modeless, all fields in the form loose their function, except the buttons but at least I can work in the opened spreadsheet.</p>
  
  <pre><code>UserForm1.Show vbModeless
  </code></pre>
  
  <p>How can I get both? I want to work in the opened spreadsheet and continue on the form when done.</p>