username & passsword for each sheet to make it visible on a shared workbook

[aravindhan_31]

Hi,

Thanks for all your help so far. I learnt a lot from here. I need your help or guidence on the below:

I have some 50 sheets in a file dedicated to 50 people. As of now everyone one can see those 50 sheets. and amend the data.

I want to protect this, however i can protect each sheet with passwords and ask the user to unprotect it. But the requirement is one person should be able to see only his sheets. so what I thought is.

1. I will create one master sheet with usernames in Column A & passwords in Column B this sheets will be protected with the passwords ( or we can use the usernames and passwords in the code)

3. I will give the their usernames and passwords to all those 50 people respectively.

2. there will be another sheet called Macro sheet where Everyone can see only the Macro sheet when they open, where they can see the userform to enter username and password.

3. If the user enter the user name and passwords the respective sheets should be visible.
I have attached a sample for reference
Thanks for your help

Arvind

[abdul gani]

sir

attached excel doent exit the macro ( not working)