Close Userform in Excel

  Desert Andy 14:19 21 Dec 06
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 06

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos