Not very clear, or at least not anything like the original request.

My code prompts for a password when you click a command button on one form. If you enter it correctly it closes that form and opens a new form.

If that's not what you want, provide details, the code you're working with, and a sample workbook.