PDA

View Full Version : Stop Excel Showing



pcsparky
02-05-2009, 04:00 AM
I'm trying to get my splash screen to show with Excel hidden using Application.Visible = False in the Workbook Open sub of the workbook. However, Excel still trys to open initially.

Is there any way to stop Excel trying to show before this code is executed?

Bob Phillips
02-05-2009, 04:53 AM
This sort of code works fine for me



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

pcsparky
02-05-2009, 02:27 PM
That's exactly the type of code I have but the background of Excel opens briefly before the Application.Visible = False code runs and the userform opens so it doesn't look very neat.

Bob Phillips
02-05-2009, 04:25 PM
Well it will, because it starts up before it opens any workbooks and before it runs any code.