Creating a Splash Screen

David is using Excel 2000, and has created a splash screen by using a user form in VBA. (How you create user forms has been covered in other issues of ExcelTips.) Like other splash screens, the user form stays visible for a short time, and then disappears. David wants to modify the user form so that the close button (the "X" in the upper-right corner) is not visible and that, preferably, the title bar is not even visible.

There is no direct way to remove the close button from a user form, but it can be done with an API call. You can find additional information on how to do this (it is rather involved) at this Web site created by Stephen Bullen. Scroll most of the way down the page and look for the file called "NoCloseButton.zip."

http://www.bmsltd.ie/Excel/Default.htm

Instead of relying on Windows API calls, you can simply disable the close button so it has no effect. You can do this using this type of code:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CloseMode = 0 Then
      Cancel = True
    End If
End Sub