Password Protect Sheets From Viewing

Dear All

I have a excel file with around 8 sheets in it and this file puted in the network to be shared with 8 persons So i need to make an individual password for each one to enter to his specific sheet and have full authorization to make anything in it and this done using userform where each one when open the file in the network , a user form open in first stage to select his name and put his own password with the ability to let each one to make his own password or change it from the userform

Please note that this file is shared so it may more one user open it and it may be there an save funtion at same time ( same time & same activities )

So if there any one have any examplr for this or can help to build the VBA i will be appreciated

Best Regards
M.Alaa

Re: Password For Shared File By User Form Input

What is the username and password
And i enter a wrong username and password and the file didn't close automatically

Re: Password For Shared File By User Form Input

Dear Sir

I have a littel information about the VBA codes so when i see this codes i could adjust it but in you codes i tried to apply it in an excel sheet and there is no reaction . if there any real example for it so it may help me

BR

Re: Password Protect Sheets From Viewing

Dear All

i tried this example but i need to make thing like the attached file where i put the 8 users mane in the code and let them to make them password by themselves with the ability to change it and this is done like royUK example plus when each user choose his name and put his password , the sheet no. which is already related to this user name will be open directly

And don't forget as i said that this file is shared file and the possibility to make multi ( Copy or Paste ) function in the same time is big so i need to put it in the consideration

Best Regards

[SIZE="2"]Edit: Will Riley (deleted attachment)[/SIZE]

Re: Password Protect Sheets From Viewing

I am not asking for free application but asking about similar ( Very similar ) example to my needs so if you advise me with more examples to be able to see different shapes . I will be appreciated

Thansk for your quick reply

Re: Password Protect Sheets From Viewing

Dear Dave

First: as i said before that i have a little information about VBA and i tried the codes of Roy ( It is work ) and the codes of you i couldn't work with it ( May be that i don't know how can deal with external code (outside excel sheet) )

Second: the picture which i uploaded is from another excel sheet which is downloaded from this site and this sheet is totally different from what i want but when i uploaded this ( I want the shape only )

Third: You must know that if i tried to make a code or example so it is for sure that i will attached it to let you help me ( it is not a secret ) and i think that this forum and this site contains huge information Which can not be imagined AND IT IS BETTER TO ME TO UPLOAD MY WORK TO FIND USEFUL HELP

So if you need the excel sheet that i uploaded the picture from it so please find it

I hope that there is no any misunderstanding for this situation and i am really need some one expert in this program to help me not in this topic but in another future topics
Best Regards

Re: Password Protect Sheets From Viewing

the pasword is (michael)

Re: Password Protect Sheets From Viewing

As i sent before the picture ( I NEED ONLY the shape of the picture what i sent ) for the user form of my worksheet

YOU must know that untill this moment i am not trying to make a code or adapt any code .

So are you will help me or not Where i hope to do that

thanks
BR

Re: Password Protect Sheets From Viewing

Dear Roy

Could you please tell me what you want to do ? Where i don't need to losse anyone who could help me

Best Regards