View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HH[_4_] HH[_4_] is offline
external usenet poster
 
Posts: 42
Default Splash Screen / userform

I have a splas screen showing with this code:
Private Sub UserForm_Activate()
Const SS_DURATION As Long = 5 'seconds
Application.OnTime Now + TimeSerial(0, 0, SS_DURATION), "KillTheForm"
End Sub

Is it possible to have the splash screen show without anything behind them
for 5-10 seconds or while the workbook is loading.

What I want the user to see is the splash screen alone for a short time. No
Excel worksheets, No Excel tool bars, etc.

Hank