Excel VBA - Close Event for Password Userform

M

Marcolino

Is there a way to program a close event for a password userform, so that if
the user tries to close the form before entering a password, it generates an
error message and reloads the form?
 
M

Marcolino

Would this also prevent a user from simply clicking on the X in the top-right
corner of the userform, which simply ends the subroutine?

I can't seem to add a control to that X to prevent this from happening.

Thanks
 
Top