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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top