Thread: Password to be able to close a form

Hey,

I have a small database where i want some of my employees to add information. Some of these are just not that smooth with computers in general so i want to protect my database in some kind.

So my solution was that i do a modal form so they cant click on things around it but its still possible to "close" it down. I want the close button there for my use. what would be nice was if i could protect the close button in some way so that they cant close the form down whenever they please or missclick.

Is there some way to passwordprotect the "close" button.

Or would there be some better way to make the form so its no possible to get inside the database itself?

You can use code to prevent the user closing the form with the red X, then add a button that requires a password before closing.

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
  If CloseMode = vbFormControlMenu Then
        Cancel = True
        MsgBox "You can't close the form like this! Please use the buttons on the form"
    End If
End Sub

This will probably cause problems closing the workbook. The simplest solution is to make the data sheet very hidden