Hi, I have a macro which basically you click on and it brings uo a form
(Userform2) which you input a password and it unprotects a sheet. what I wish
to do it once the button is clicked display a additional userform (Userform1)
for say 3 seconds saying well done then hide the userform and carry on as
normal.
I have tried the following but does not work :
(put in the userform2 button code)

Private Sub CommandButton1_Click()
UserForm2.Hide
UserForm1.Show
timeDelay = 1
UserForm1.Hide
End Sub

Please help me

Regards