Hello forum
Hello every one
Please if you can help me to finish this file
How to make to access with password .. each user has their password in sheet " DATABASE " .. with 3 attempt
Thank you in advance for help
Cordially
AKRAMI
login multiusers.xlsm
Hello every one
Please there is no idee for this problem
Cordially
AKRAMI
Hello AKRAMI,
I have modified your "Database" page to include a new column labeled "Locked". There is a cell for each user. If it is TRUE then the user can not login until the "Locked" cell has been changed back to TRUE. The user will be locked out after 3 failed attempts.
The Table on "Database" has three dynamic named ranges: Users, Passwords, and Locked. You can add or remove users from these lists and not have to modify the UserForm code. The attached workbook has all the changes made to it.
UserForm Code
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hiiii master Leith Ross
Thank you so much for the help
Thank you also for your great file and code and work
That's what I want
I only have a small problem to end this file
I put in your file a piece of code to save the accée users but I was not able to continue the rest of code to perform this operation
Thank you in advance for help master
Cordially
AKRAMI
Hello every one
please ..there is not any idea for finish the dynamite factory
thank you in advance
AKRAMI
Hello every one
Please how to do make for finish the problem
Cordially
AKRAMI
Hello
but why no one wants to help me
Hello AKRAMI,
Here is the latest version of the workbook. The worksheet "Database" is updated when the user logs in and out. When the workbook is closed, the user is asked if he or she would like to log out. If the answer is yes, the user is logged out, the workbook is saved, and then the workbook closes. Try this out and let me know what else you need.
Hiiiii Leith Ross
Thank you very much for help me
Is only what I can after the third attempt the userform definitively closes
Thank you in advance for help
Cordially
AKRAMI
Hello AKRAMI,
Sorry, I am not sure what you mean. Can you give me an example?
Hiii master
Thank you for your precious time for help me
If I want to enter this file with a fake password ..then after the third attempt, the file is automatically closed
and one leaves this message without file "you want to save changes"
Thank you in advance
Cordially
AKRAMI
1.jpg
Hello AKRAMI,
Do you not want the workbook to close after 3 failed login attempts?
Hello master Leith Ross
I want the workbook closes after 3 wrong attempts
Thank you in advance
AKRAMI
Hello AKRAMI,
I have made the change to close the UserForm after 3 fai;led attempts. Let me know if anything else needs changed.
Hiiii Leith Ross
Yes thank you for closing a userform after the third false attempt ..
Finally, and in reality I only have this problem..i want to distribute sheets by different users as this picture shows.
Thank you in advance master for your help and patience
Cordially
AKRAMI
1.jpg
Last edited by AKRAMI; 10-15-2015 at 12:14 PM.
Hello AKRAMI,
I updated the workbook to close and save the changes after 3 failed logini attempts.
Hiii Leith Ross
Thank you master
Thank you very much for your excellent file and your impeccable codes
Yes that's exactly what I want
Please it remains for me to finish this file except what I would like to do in my post#15
Finally, and in reality I only have the last problem..i want to distribute sheets by different users as this picture shows in my post#15
believe me master Leith Ross I do not want to disturb you but only I want to adapt a single file by a single person .. I am newbie and if I mix other codes someone else I can not understand
Thank you in advance master for your help and patience and for pecious tome for help me
Cordially
AKRAMI
Thank-you2.jpg
Hello AKRAMI,
If I understand your picture correctly then the user should only have access to worksheet names that have an "x" . Is that correct?
Hiiii master
AKRAMI1 "admin" can access in all sheets
AKRAMI2 can access to sheet 2 sheet4 sheet6 sheet8
AKRAMI3 can access to sheet 3
AKRAMI4 can access to sheet 3 sheet 4 sheet 5
AKRAMI5 can access only to sheet 9
Cordially
AKRAMI
Hello AKRAMI,
Okay, I can do that. Can you post a copy of the workbook shown in post #15?
Hiii master
This is a workbook in post#15
Cordially
AKRAMI
LOGIN LEITH ROSS ver 2.xlsm
Hello AKRAMI,
I added two more macros to this workbook. One macro hides all sheets except Fueil1. The other macro shows only the sheets for the user according to the Database worksheet.
ShowUsersSheet is called in the "Validate" button on UserForm1. HideSheets is called in the "Workbook_BeforeClose" event.
Here is the code that was added to Module1...
Please Login or Register to view this content.
Hiiii master Leith Ross
Thank you very much
Congratulations for this wonderful work and codes
Thank you very much for your patience,
Thank you very much for your followed my subject and help me
Thank you for your kindness
It is perfectly resolved
Sincerely
AKRAMI
1.jpg
Hello AKRAMI,
You're welcome. It has been a fun and interesting project.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks