VBA Login Form not Working

[Amitdas]

Hi, Expert I am new in a Excel. I went to get you expert solution for Excel VBA. I create a Excel Data entry UserForm & Excel LogIn From Option. But I face some Problems, When I open the Excel file then First show log in option But when I cancel the loginform then it show my Data Entry userform2. This issue is my Problems.

NB: login Form1 is working but when i cancel then it show the Data Entry Form2.

 

[Amitdas]

Yes all of think i have to understand to you,

Only one things e.g when i trying to re open the excel sheet again after 2 or 3 minute , the excel sheet is opening without any login form.

this is the problem i can not understand to you clearly.

we are in Excel 2016

 

[Logit]

.
You can use GOOGLE TRANSLATE to better understand me.


I was able to reproduce your problem by clicking on the UserForm RED X in the upper right corner ... instead of clicking on the QUIT button.

To stop that error, I placed this macro in the UserForm2 macro code :

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
  If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Please use the Close Form button!"
  End If
End Sub

Download workbook : https://www.amazon.com/clouddrive/share/EuwoDEFfwNLfE7VXduYGHkm08OaQ0q5D03010ipQkKg

 

[Amitdas]

Thank you so much. At last it was work properly.

 

[Logit]

.
You are welcome. Glad to help !

 

[COwen]

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

If CloseMode = vbFormControlMenu Then
    Cancel = True
End If

End Sub

This code prevents the use of the red "X" in the userform.

 

[Fluff]

Which is exactly what Logit said almost a year ago!!