Thread: Hiding Sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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......