Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide the Excel screen
I need hide the excel screen, after start up the UserForm, I want show
only the UserForm. How I do it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide the Excel screen
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide the Excel screen
You can use the Visible property to hide the main Excel window. E.g.,
Application.Visible = False -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "tetors_2002" wrote in message ... I need hide the excel screen, after start up the UserForm, I want show only the UserForm. How I do it. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide the Excel screen
Thanks guys.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide screen movements when a macro is running | Excel Discussion (Misc queries) | |||
Hide function: "Cannot shift objects off screen"? | Excel Worksheet Functions | |||
how do you hide the send email screen in Excel? | Excel Discussion (Misc queries) | |||
How do I hide words on a printed document, but see on screen? | Excel Discussion (Misc queries) | |||
Hide the principal screen | Excel Programming |