T tetors_2002 Sep 8, 2003 #1 I need hide the excel screen, after start up the UserForm, I want show only the UserForm. How I do it.
I need hide the excel screen, after start up the UserForm, I want show only the UserForm. How I do it.
T tomhaddock Sep 8, 2003 #2 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
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
C Chip Pearson Sep 8, 2003 #3 You can use the Visible property to hide the main Excel window. E.g., Application.Visible = False
