Maybe try to hide only the x button and not the whole bar:
Private Const GWL_STYLE = (-16)Private Const WS_SYSMENU = &H80000
Private Declare Function FindWindow Lib "User32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLong Lib "User32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLong Lib "User32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare Function DrawMenuBar Lib "User32" (ByVal hWnd As Long) As Long
Private Sub UserForm_Initialize()
Dim FndForm, tpe
FndForm = FindWindow(vbNullString, Me.Caption)
If FndForm <> 0 Then
tpe = GetWindowLong(FndForm, GWL_STYLE)
tpe = SetWindowLong(FndForm, GWL_STYLE, tpe And Not WS_SYSMENU)
DrawMenuBar FndForm
End If
End Sub
Hope this helps