Option Explicit
Dim pausetime, start
Private Sub UserForm_Activate()
'
pausetime = 0.1
start = Timer
Do While Timer < start + pausetime
DoEvents
Loop
ActiveWorkbook.Save
Me.Hide
Unload Me
'
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then Cancel = True
End Sub