title: How to close a userform and open another in VBA
body: <p>I have one userform in the workbook "main.xlsm" that opens upon opening the workbook, on this userform i have one button that opens another workbook "test1.xlsm". In the "test1.xlsm" workbook i have a userform that opens upon opening the workbook, on this userform i have one button that closes this workbook and saves it. The idea was that after closing the userform from "test1.xlsm" i should get back to the userfom from "main.xlsm", but on the line  <code>Workbooks("test1.xlsm").Close</code> it closes all the opened userforms</p>
  
  <p>this is the code for the button from the userform in "main.xlsm" :</p>
  
  <pre><code>Private Sub CommandButton1_Click()
      Workbooks.Open ("D:\test1.xlsm")
  End Sub
  </code></pre>
  
  <p>this is the code for the button from the userform in "main.xlsm" :</p>
  
  <pre><code>Private Sub SaveButton1_Click()
      Workbooks("D:\test1.xlsm").Close SaveChanges:=True
  End Sub
  </code></pre>