Hiding Sheets
You can hide Excel so only your userform is showing.
To hide Excel when the form as activated:
Private Sub UserForm_Activate()
'Hide Excel when this form is activated
Application.Visible = False
End Sub
To show Excel again when the form is unloaded (In this example, the code is
attached to a command button on the form).
Private Sub cmdExit_Click()
'Close the form and show Excel.
Unload Me
Application.Visible = True
End Sub
Hope this helps,
Hutch
"millwalll" wrote:
Hi all.
So far I have a sheet and I Have a Form. I want to hide the sheet so that
soon as I open my file, all I want to see if the form. Is this possible ??
Thanks all......
|