runtime 13 type mismatch

If you are simply trying to close your app ... just use:

Application.Quit

Ok, yes, but my problem is that I have a login frame that pops up on opening the workbook, if the user closes the login frame with the cross in the upper right corner he can just start working without entering the right password. So, what I try to do is to put a Application.Quit in various places when the user tries to push some other buttons and won't I need to put the Application.Quit inside an "if" that checks if the login is made or not???

Or do you have another solution for me?

Here is a complete macro that you can paste into your form's code. It disables the X close method and provides
instructions to the User how to proceed:

Private Sub UserForm_QueryClose(Cancel As Integer, _
  CloseMode As Integer)
  If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Please use the CLOSE button.", vbExclamation, "Event Error"
  End If
End Sub

You can add your own code to the form to close it after the above or direct the user elsewhere.

Works like a charm

Thanks a ton!

I started with VBA yesterday and have a long way ahead of me, maybe we will talk again

Use this line of code instead. It disables the X on the form:

If CloseMode = 0 Then Cancel = True

That will make them use your method of closing the form or progressing.

Absolutely. I'm still learning ... alot from all kinds of folks here. Been messing with VBA for about 1 year. Lots to learn.

If this answers your question, please mark the Thread as Solved. Up top, right side. "Thread Tools"