Hello,
Trying to swap between two userforms in different books.
Let say workbook1 is open and its userform1 is loaded. On userform1 there is a button that opens the workbook2 with userform2. Userform2 has button "Close"
Why click closes Userform1 as well ? I want Userform1 remain on the screen. Or to be reloaded.
Trying to swap between two userforms in different books.
Let say workbook1 is open and its userform1 is loaded. On userform1 there is a button that opens the workbook2 with userform2. Userform2 has button "Close"
Code:
Private Sub btn_close_Click()
Userform2.Hide
ActiveWorkbook.Save
Workbooks("Workbook1").Activate
Workbooks("Workbook2").Close
End Sub
Why click closes Userform1 as well ? I want Userform1 remain on the screen. Or to be reloaded.