PDA

View Full Version : Hide the form on a worksheet



morteza2006
02-08-2013, 06:58 AM
My teacher if I want to be hidden somewhere in the image below in red, what code should I write?:clap:: pray2:

Bob Phillips
02-10-2013, 04:10 AM
Me.Hide

Artik
02-10-2013, 10:14 PM
I think it's something like this (in UserForm module):
Option Explicit


Private Sub CommandButton1_Click()
Application.Visible = True

Me.Hide
''or
'Unload Me
End Sub


Private Sub UserForm_Activate()
Application.Visible = False
End Sub


Private Sub UserForm_Terminate()
Application.Visible = True
End Sub
Artik