Reply to thread

Message: [QUOTE="John_J, post: 6345082"] Here is the end result for the un-hide operation: 'In the sheet where I have the button to call the UserForm: Private Sub CommandButton1_Click() Password.Show End Sub 'The UserForm Cancel button: Private Sub CancelButton_Click() Unload Me End Sub 'The UserForm OK button: Private Sub OKButton_Click() If TextBox1.Text <> "secret" Then MsgBox "Invalid Password" Exit Sub ElseIf TextBox1.Text = "secret" Then Worksheets("Sheet2").Visible = True Worksheets("Sheet1").Visible = True Worksheets("Sheet1").Activate Unload Password End If End Sub The UserForm has a TextBox with TextBoxCharter set to "*", and the form is called "Password" -- John [/QUOTE]