UserForm Property (97)

Topic

New Reply

I have a UseForm that prompts for a password and it works beautifully except for one oversight. The close icon (the X at top right) can be clicked and the form closes exposing the works.
I’d be really chuffed if someone would supply the code to prevent this from showing.

Cheers

Rob

Reply | Quote

Replies

Use the following code (place it in the Userform code module) to prevent closure by use of the x button

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then Cancel = True
End Sub

Andrew C

Reply | Quote

Thanks Andrew. That’s tidied up project nicely.

Cheers

Rob

Reply | Quote

Another thing to do is to hide all that must be hidden from view once no or a wrong password is entered. Then unhide what may be seen once a valid password is entered. This also avoids trouble when a user opens the file with macros disabled.

Reply | Quote

Thanks Jan Karel for the advice.

Cheers

Rob

Reply | Quote