Botón cerrar excel

Despacio, yo se que quieres volar, pero primero debes caminar.

Con esto quitas la X, debes copiarlo al principio del código del userform, no va dentro de un función, va al principio.

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

Para guardar y cerrar excel

Private Sub CommandButton1_Click()
ActiveWorkbook. Save

Application. Quit
End Sub