code to enter password

**jimbolhp** · 04-25-2012, 03:55 PM

Greetings!

I have a master form which is password protected. It contains a macro to open form 2. I would like to password protect form 2. My question is: What would be the command line to enter a password, i.e. newform111 when prompted by form 2?

I really appreciate this forum. Thanks very much!

**Paul** · 04-25-2012, 04:52 PM

Hi Jimbo,

You could probably use something along the lines of the following, which would be linked to a commandbutton (or other object, change as needed) on userform1:

Please Login or Register  to view this content.

If it's important that users don't know this password, you should protect your VBA code in the VB Editor (Tools > VBA Project Properties > Protection > check Lock Project for Viewing and set a password).

**jimbolhp** · 04-25-2012, 08:20 PM

Thanks for this. At the risk of showing my ignorance (probably obvious) the command is in the middle of a long complicated routine, designed to automate an order entry process. I was hoping to post information to a separate workbook in the middle of that routine without any operator input. I hope I'm being clear.

Thanks,

Jim Burns

**Paul** · 04-25-2012, 08:22 PM

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.

**vpnvipin** · 04-26-2012, 03:14 AM

Hi paul,

what command should we use to hide passwords while typing or entering in inputbox, I mean like webpages what we have to use so that others can't cme to knw or see while we type the password?

**royUK** · 04-26-2012, 04:47 AM

Originally Posted by vpnvipin

Hi paul,

what command should we use to hide passwords while typing or entering in inputbox, I mean like webpages what we have to use so that others can't cme to knw or see while we type the password?

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.