I am using the following to prevent a user from closing a form but I also want prevent a user from saving or closing excel except if they use my user form buttons. Is this possible?

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Application.DisplayAlerts = True
MsgBox "Sorry, you may not close the form like that!"
Cancel = True
Application.DisplayAlerts = False
End If
End Sub

Hi Randy,

showing the form as modal,

Userform1.Show vbModal

could help.

Martin

but how do I disable the user from saving or closing excel when I close or hide the user form

You'll need API calls for true disabling of the close button in the application menu.

I attached an example of a pure VBA approach, see if it helps...

Martin

That was just what I was trying to do

Thanks again

Glad to help,

you're welcome

Martin