Password Protection Formula - Remembering I already entered the Password!

Hello,

The Add Data Button has a Password protection which works really great - but the issue was brought up that when the User enters the Password the first time there is NO issues with this... but if the User closes the Userform and does not close the workbook, and wants to add more data to the Userform again, the User has to re-enter the password...

The question was raised that can't there be a code or formula that can be written to see that the User is still in the workbook and a password is not required because it was already entered correctly the first time?



Best Regards

I am not able to answer this, but would raise a question instead.

Wouldnt it be better to force the use to re-enter the PW each time, in case user2 uses the file while user1 is away for a few minutes?

We have the same ctrl alt del here, but many users still dont follow that practice. Anyway, it was just a thought

My recommendation:

1) select a hidden location in your workbook somewhere and write down the "Password OK" flag when someone successfully logs in. This will survive the form being closed

2) Add a check of that cell to your userform initialization sequence. If that cell say "Password OK", it skips the password check, else it forces it.

3) Add a Workbook_BeforeClose event that will clear this cell and save the doc

Hi JJFletcher,

What JBeaucaire suggested makes perfect sense, as it is exactly what I do with multiple access levels. I sounds complicated, but it is not really.

The lines of code are pretty simple, you will have to work out in your form initialization where they go and if they need "tweaking".

When password is successfully entered, this would write down a note on a given sheet to that fact:

Please Login or Register  to view this content.

In your form code where you're about to start the process for asking for the password, you would check that cell above first:

Please Login or Register  to view this content.

Would it be possible to never unload the user form until the Workbook_BeforeClose event.
Just Hide it instead? Thus the PaswordOK status wouldn't be lost when the user form was unloaded.

Use a Userform.Hide instead of Userform.Unload.