How do I elimninate the built in close button?

[rollinshultz]

I am using the User Form to hide the spreadsheet and I have provided a close button which closes the form and the spreadsheet. My problem is the X button on the User Form closes only the form, leaving the spreadsheet exposed.

 

[Ingolf]

Hi,

Try this:

Private Sub UserForm_QueryClose(Cancel As Integer, _
  CloseMode As Integer)
  If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Please use the Close Form button!"
  End If
End Sub

from here:

Create an Excel UserForm