File Multi - User password

[Mart Marti]

Hello Forum
Hello to all
Apologies for the language because I do English perfectly blade
and I just use the translation
I'd like to do a multi-user file with password and username.
at the opening of every file goes through a ..ADMIN passwords and other users
even if the file is opened a thousand times no days .. on tappe password so 1,000 times even for the ADMIN
this file should automatically closes after 3 false try.
I want an example with 3 levels: level 2 standard and level 1 ADMIN.
The Standard Level 1 users have the opportunity only (read only). The Level 2 users can only enter the data in specified leaves no ADMIN and does not have the power to remove or modifiier and will be forced to change their passwords after a limited period (eg every 30 days)
ADMIN does not need to change their passwords
I hope I was clear and I hope you can help me because I admit I seek without success.
thank you in advance for the help
thank you in advance for any suggestion suggestion ..
Best regards
MARTI

[BlindAlley]

http://www.vbaexpress.com/kb/getarti...e.php?kb_id=33

Minch’ duk’ spasum yen inch’ - vor meky galis miasin , yev apahovel pataskhany . Ays kayk’um bats’atrum e, t’ye inch’pes e da karogh e anel.

or is it:

Մինչ դուք սպասում են ինչ - որ մեկը գալիս միասին, եւ ապահովել պատասխանը. Այս կայքում բացատրում է, թե ինչպես է դա կարող է անել.

[BlindAlley]

Fellow ես միայն Google Translate նույնն է, ինչպես Դուք եք արել, ոչ պետք է երդվում ինձ.

Which means:

I only used Google to translate my advice into Armenian - there is no need to swear at me in five languages.

[Mart Marti]

Fellow ես միայն Google Translate նույնն է, ինչպես Դուք եք արել, ոչ պետք է երդվում ինձ.

Which means:

I only used Google to translate my advice into Armenian - there is no need to swear at me in five languages.

Hiiii BlindAlley
Apologies I'm wrong translation
cordially
MARTI

[FDibbins]

Mart marti, I sent you a PM, please check and reply

[mikerickson]

The attached has a user form that requires the user to enter their username and password before proceeding.
It also has the capability of restricting access for different users.

Currently:
UserName Password
admin admin
User1 User1pw
Sandeep password
User2 User2pw


Any user can change their password.

Any user whose username starts with "admin" has administrative access.

Administrative access can see any sheet, add or remove users, change the access of any user, reset a users password (but not detect their current password or change it to anything other than the default )

Passwords are case sensitive, usernames are not.

[Mart Marti]

2.png

The attached has a user form that requires the user to enter their username and password before proceeding.
It also has the capability of restricting access for different users.

Currently:
UserName Password
admin admin
User1 User1pw
Sandeep password
User2 User2pw


Any user can change their password.

Any user whose username starts with "admin" has administrative access.

Administrative access can see any sheet, add or remove users, change the access of any user, reset a users password (but not detect their current password or change it to anything other than the default )

Passwords are case sensitive, usernames are not.

Hiiii MIKERICKSON
thank you for help me
a little problem please see this picture
cordially
MARTI

[BlindAlley]

Hiiii BlindAlley
Apologies I'm wrong translation
cordially
MARTI

Apology accepted Marti

[mikerickson]

Attachment 405111
Hiiii MIKERICKSON
thank you for help me
a little problem please see this picture
cordially
MARTI

I see the picture but don't see what your problem is
UserDelimiter should be declared as a constant at the start of the frmAccess Userform code module.
The code you highlighted should also be from the same module.

What error is that line causing?

[Mart Marti]

Hiiii MIKERICKSON
thank you for help
this problem is solved
but i have please and thank you in advance
how to change passwords
also how to change password for char it appears the stars
cordially
MARTI

[mikerickson]

If you log in as admin, there is an option to press YES for administrator functions.
There you can add, delete users and control their access.

You should note that there are two kinds of access control. One specifies which sheets a user is allowed to see, the other which sheets a user is forbidden from seeing.

The difference isn't meaningful until a new sheet is added after the access levels are set. If the user is "allowed to see X, Y, Z" style access then they will not see the new sheet. If a user has "forbidden to see A, B, C" style access, they will be permitted to see the new sheet.

[Mart Marti]

33.png

If you log in as admin, there is an option to press YES for administrator functions.
There you can add, delete users and control their access.

You should note that there are two kinds of access control. One specifies which sheets a user is allowed to see, the other which sheets a user is forbidden from seeing.

The difference isn't meaningful until a new sheet is added after the access levels are set. If the user is "allowed to see X, Y, Z" style access then they will not see the new sheet. If a user has "forbidden to see A, B, C" style access, they will be permitted to see the new sheet.

Hiiii master
thank you for the explanation and pou help
Please, I have two questions:
1-how to remove these two definitely name and leave only (admin + user1 + user2) please see (red arrow)
2-how to add or remove sheets to any user (arrow Green)

[mikerickson]

1) To remove a user
Select the user that you want to remove from the drop down in the upper right of the administration dialog.
Press the Delete User button and confirm

2) to control access
Select the user whose access you want to control from the drop-down.
The user's current access will be shown in the Listbox and in the Deny/Grant access checkbox.
Change the access to the desired access and press UPDATE ACCESS.

Note that all users have access to the sheet whose tab name is MasterSheet, code name Sheet1. This can be controlled in the UserForm Intialize event.

Please Login or Register  to view this content.

[Mart Marti]

thank you teacher MIKERICKSON
thank you for help
thank you for the explanation
thank you for your sacred time has help me
cordially
MARTI
thank you.jpg

[Mart Marti]

Hiiii master
Apologies for the derangement
I have one comment
I have choose for user1 : (sheet AAA + sheet BBB)
I have chosen for user2: ( sheet CCC + sheet DDD )
for user1 it works very well but for user2 it does not work I have for him choosen
thank you in advance for solve my little and last problem
cordially
MARTI
admin et utilisateur 1.xlsm

[mikerickson]

My guess is that you might have the Allow/Deny setting different.
Also, there has to be at least one sheet that everyone can see.

[Mart Marti]

My guess is that you might have the Allow/Deny setting different.
Also, there has to be at least one sheet that everyone can see.

Hiiii MIKERICKSON
in any case thank you
cordially
MARTI

[vkalz]

Hi MIKERICKSON

Can I use this password for another workbook? How to assign a Macro to a button?

Regards

Vvk