Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
XL2003 on XP
I have a UserForm set up as a splash screen that fires with WorkBook code: Private Sub Workbook_Open() Userform1.Show End Sub Sub KillForm() Unload Userform1 End Sub And the code behind the UserForm: Private Sub UserForm_Initialize() Application.OnTime Now + TimeValue("00:00:06"), "KillForm" End Sub If the user kills the splash screen before it times out, and then closes the application without closing the instance of Excel, the application will start up again after the selected time out period. After that, even if the splash screen times out, this repeats when you try to close only the application. Can anyone explain what causes this effect? -- Al C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Splash screen | Excel Programming | |||
splash screen | Excel Programming | |||
Splash screen and various screen resolutions | Excel Programming | |||
Splash Screen | Excel Programming | |||
VBA splash screen | Excel Programming |