Password Protect Sheets From Viewing

    Re: Password Protect Sheets From Viewing


    Dear Roy


    This is really encourage me but i am really trying to search in this forum and another forum but i am not found similar thing for what i need


    Your examples in this forum really help me to build my application according to my needs but the points which i mentioned i couldn't recognize them.


    So i hope to guide me to find the solution for my points


    Thanks a lot
    BR

    Re: Password Protect Sheets From Viewing


    I don't have any experience of sharing workboks, as i said, I wold rather use individual workbooks & consolidate.


    If the password code is Ok try starting a new thread about the sharing part.

    Re: Password Protect Sheets From Viewing


    Dear Roy


    I separated the sharing part in new thread as you suggested But i still need your help in the other points


    1: According to the user. They need to put them password by themselves and they need the ability to change it (like any regular password) so how can make this option?


    2: If you see my work you will find that I put 7 user in combo box and each user will see his own sheet when he put his password but the user name NG has the ability to see all other users sheets . Now I need to update any changes in the users sheets to the master sheet of NG user . How?


    3: You will see that I put in each sheet a commandbotton to save copy in path and exit the sheet but I need to deactivate any other exit command in excel sheet and let this button only to exit the excel sheet . How?


    Best Regards

    Re: Password Protect Sheets From Viewing


    1. As I said earlier you will need to re-write the password validation to compare passwords stored on a hidden sheet. Also, create a form to enable the user to change the password. I ma sure some of my earlier examples offered this option.


    2. I can't advise on updating without some idea of what your data layout will be


    3. Put this in the Before_Close event


    Code
    Option Explicit


Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox "You must use the button provided"
End Sub


    I am expecting visitors so I will not be able to do any more until this evening.

    Re: Password Protect Sheets From Viewing


    Dear Roy


    After extremely searching in this forum i found an example have the change password function and i adapted it to my needs so find the updated attched file


    Please i need clrification for some points:


    1: First ,your closeing code not working with me ( I don't know ) and i need to only close every sheet from my save & exit button . How?


    2: if you see the code you will see that i put every sheet name in it so if there any way to take it from the config sheet


    3: If you see that i let user NG see all the other sheet . I need to put a limit to it to just read and copy from it ( How ) ?


    Best Regards

    Re: Password Protect Sheets From Viewing


    You have completely changed the code, ignoring what I amended for you. We are getting nowhere, I have tried to help you but at post #46 we are back to square one. In addition I have told you that your planned application won't work. I'm sorry but I haven't the time to spend on this.

    Re: Password Protect Sheets From Viewing


    Dear Roy


    Please be patient with me


    I am really lost after reading your post


    I don't know what are you meaning about back to square one


    I told you that i found an example to make a change password and adapt it to meet my requirements so where is the wrong thing in this doing ??


    and i am really appreciate your helping me and any advise from you i do it as you said


    Now where is my mistake ?? and my last example is worked


    BR

    Re: Password Protect Sheets From Viewing


    Dear Roy


    From the history of this thread . You could see that the only one how continue with me is you . So i need to now if you will continue or not . Because i waiting for reply each time i post new thing so ...


    Best Regards

    Re: Password Protect Sheets From Viewing


    I am at work, please be patient as I keep saying. I am also reluctant to spend any more of my private time on this because I have no doubt that the methods you are proposing will not work. It will fail when you try to share the workbook, give each person a separate workbook, and use code to consolidate to a master workbook!

    Re: Password Protect Sheets From Viewing


    Dear Roy


    I am so sorry for asking help in this object . I am i nwork to and i check my post every 15 mins


    i will try to find a way to solve it and if you have a new please tell me


    BR

    Re: Password Protect Sheets From Viewing


    mbluethunder700
    Member


    Reading Roys post just before my own, i must ask kindly that You leave Roy alone from now on, OzGrid does not allow this behaviour as its rules. Or in fact You can add anything i as OzGrids Administrator dislike and want to stamp out from OzGrids members - so lets call it a day there. Please do not contact Roy directly regarding this matter I would see this as harassment


    jiuk

    Re: Password Protect Sheets From Viewing


    Yikes...Dave, Roy, Will, et al, you may wish to post this as an example of how NOT to ask for free help. I give you all credit for trying as long as you did with this one, and yet continuing to help those that are more patient and interactive.

    Re: Password Protect Sheets From Viewing


    Dear ALL


    Really, i don't know why this attitude regarding to my thread ??!! . I think that i was more polite to say "Sorry" on this thread and on public for my behavior . But i don't think that it is not good to take this thread as an example to every one try asking help .


    Honestly , It is a first time to me to write or talk in a forum like this , I am really surprised when i saw the people who are working hardly on this forum and i am really respect there effort to keep the rules applied on this forum.


    First time when i saw this forum and saw the extremely lot of number of threads in it . I admired with it and i was sure that i will find the one how could help me . And the help which i needed not doing a thing to me but find a someone but me on the right road .


    And Honestly , Roy is the one who help me a lot and but me on the right way . and i am really really appreciate his effort to do that and i was very interactive when he replies to me . Thanks a lot Roy , Thanks Really.


    Finally after this experience with this forum I see that any one who need or want to do any thread on it. He should know that there are amazing staff working on it and they will not let any one to break the rules of this forum.


    Thanks a lot for this forum and its staff and a hope to be interactive with his members . And Sorry for my English


    Thanks Again
    Best Regards

    Re: Password Protect Sheets From Viewing


    mbluethunder700, if English is not your 1st language you should not apologise for poor English. What you should do is fill in your location in your Profile.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login