Keeping Excel App window from showing on start-up ...

[SeaLyon]

I'm running Excel 2010 and want to start a workbook (with forms & macros) without showing the standard Excel window. What I'd like is to be able to double-click the workbook and have it start by just displaying one of my forms. This works fine by placing a frmMyHomeForm.show command into Workbook_Open(), but I still get the standard Excel app window in the background. Are there any property settings or method calls on the application object (or others?) that would allow me to tell Excel not to display the standard window?

Thanks,
Chris

 

[Trevor G]

Try something like this when the form is activated

In the VBA Screen if you Press F2 this will invoke the Object Browser and you can then select Application and work out the options from there. Close the Object Browser in the normal way (Cross top right of screen)

Sub app()
Application.Visible = False

End Sub

 

[SeaLyon]

Gave "Application.Visible = false" a shot, but it didn't work. I was originally concerned that that might hide everything (including my form), but it did not hide anything. Any other thoughts?

Thanks,
Chris

 

[Trevor G]

This works perfectly well.

Private Sub UserForm_Activate()
Application.Visible = False

End Sub

What code are you currently using?

And to show another routine

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> cl()<br>Application.Visible = <SPAN style="color:#00007F">True</SPAN><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[SeaLyon]

What it does is flash the Excel base screen when the macro starts. The user sees Excel come up, then it disappears, and my macro's user-screen is shown (which is exactly what the code is asking to be done but ...). Here's my basic code:

Private Sub Workbook_Open()
  Application.Visible = False
  frmRecipeEntry.Show
End Sub

This is better, but I'd rather the user not see the Excel screen flash if possible.

Thanks,
Chris