Hide the Excel screen

  • Thread starter Thread starter tetors_2002
  • Start date Start date
T

tetors_2002

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

How I do it.
 
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
 
You can use the Visible property to hide the main Excel window. E.g.,

Application.Visible = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding a "Userform" instead of closing it??? 3
Userform hide help 1
how to reshow userform after following a link 1
Hide Userform when viewing a different workbook 3
HELP: Application.Visible issue - only hide workbook that has user 4
Userform hides by itself 1
userform and printpreview 2
Start my Application in its OWN instance? 2

Back
Top