Password Issue

[tapsmiled]

I have the following code:

Please Login or Register  to view this content.

which is to require a password prior to submitting the form. It works except if the User selects NO during the first section of code (where it says you must enter a password). I am getting an Automation error that says the Calle(Server is not available. Any ideas?

[ajryan88]

Hi,

It's a bit difficult without seeing your workbook, but please try changing "Me" to the name of the userform. This probably isn't likely to solve your issue, but worth a try.

If this fails, can you please upload your workbook.

Thanks

[tapsmiled]

The Me.Hide part was working fine when I used a password in another place. I cannot attach the workbook as it has a few hundred employee names

[tapsmiled]

What about changing the top portion of the code and not giving a NO option. Just a box stating You Must Enter a Password First with OK only.

If so, how would I do that? I copied this code from somewhere else, and I don't want to remove too much.

[ajryan88]

It's hard to say without seeing the workbook. Is there any way you could desensitise the workbook, or maybe just send a small sample?

It should work with a Yes and a No option

[Olly]

Add an Exit line:

Please Login or Register  to view this content.

[tapsmiled]

Isn't that already there?

[Olly]

Isn't that already there?

Not in the code you posted.