If your form is displayed by triggering events you can have a button on th eform that hides it and use


Private Sub cmdHideButton_Click()
    UserForm1.Hide
  End Sub
And then in your book have an event proedure that triggers the user form to show again

Sub SomeEventInExcel
  Userform1.Show
End Sub

but remember that a userform loses its variable information when hidden.