Hide the Excel screen

[tetors_2002]

I need hide the excel screen, after start up the UserForm, I want show
only the UserForm.

How I do it.

 

[tomhaddock]

Hi

A quick solution is to paste the following code replacing Userform1
with the name of your form in ThisWorkSheet.

Private Sub Workbook_Open()

Application.WindowState = xlMinimized
Load UserForm1
UserForm1.Show False

End Sub

Its does the job but you will have to see Excel start up then minimise.
Disabling ScreenUpdating won't do.

There are other ways to completely hide the Excel screen but it quite
complex (unless someone knows another way?)

Tom

 

[Chip Pearson]

You can use the Visible property to hide the main Excel window. E.g.,

Application.Visible = False

 

[tetors_2002]

Thanks guys.