From Ibby's MVP site, i found code for a splash screen when creating a new
document based on a template, the following works very well.

In the UserForm module:
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Private Sub UserForm_Activate()
    DoEvents
   ' Set the display time in milliseconds
    Sleep 5000
    Unload Me
End Sub

In a code Module:

Public Sub AutoNew()
   UserForm1.Show
End Sub

----------------------------------------------

Now, if i have a document open based on a normal template, and i attach a
custom template and want the splash screen to appear, how would the code
change.

Also, if i open an existing doc based on this custom template, how would the
code change.

Thanks

PS - Maybe these questions should have been posted in vba.userforms, but i
guess i should stay in vba.general.