LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 363
Default Splash Screen Behavior

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splash screen Steve Excel Programming 6 August 9th 05 04:53 PM
splash screen animated text in excel worksheet Excel Programming 2 February 4th 05 07:51 PM
Splash screen and various screen resolutions George J Excel Programming 4 October 3rd 04 10:15 PM
Splash Screen Michelle Excel Programming 2 August 10th 04 11:04 AM
VBA splash screen scott[_6_] Excel Programming 2 October 16th 03 09:27 AM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"