Close Userform in Excel

  Desert Andy 14:19 21 Dec 2006
Locked

Hi

I have opened a userform in Excel to accept a password, however, how do i go back to the worksheet and close the userform once the user has entered their password

Thanks for your help

  VoG II 16:18 21 Dec 2006

In the Userform's code (right click > View Code in the Visual Basic Editor) something like

Private Sub Cancel_Click()
Unload UserForm1
End
End Sub

Private Sub OK_Click()
UserForm1.Hide
End Sub

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?