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?
This sort of code works fine for me
[vba]
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
Application.Visible = True
End Sub
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Well it will, because it starts up before it opens any workbooks and before it runs any code.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
