| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VB - show userform1 (at same time) minimized application win
I'm creating a user guide ( of sorts) and I want nothing but the
Userform1 shown and the excel Application window not shown at start up when I click open the file autotabs.xls This is what I have so far.... Private Sub Workbook_Open() Application.WindowState = xlMinimized UserForm1.Show End Sub Both won't work at the same time, is there away around this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel VB - show userform1 (at same time) minimized application win
Maybe you can hide all of excel???
Private Sub Workbook_Open() Application.Visible = False UserForm1.Show Application.Visible = True End Sub But seeing that userform floating over a different application might be more disconcerting. Dr.CIMS wrote: I'm creating a user guide ( of sorts) and I want nothing but the Userform1 shown and the excel Application window not shown at start up when I click open the file autotabs.xls This is what I have so far.... Private Sub Workbook_Open() Application.WindowState = xlMinimized UserForm1.Show End Sub Both won't work at the same time, is there away around this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '-2146233079 (80131509)' in the Excel Application | New Users to Excel | |||
| Run-time error '-2146233079 (80131509)' in the Excel Application | Excel Discussion (Misc queries) | |||
| Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
| Why do minimized workbooks in Excell not show file names? | Excel Discussion (Misc queries) | |||
| Why do minimized workbooks in Excell not show file names? | Excel Discussion (Misc queries) | |||
Linear Mode
