Hi

I am relatively new to VBA and Programming code which is why i'm wondering if someone could point us in the right direction. Here is the issue

I have 12 worksheets each which have to be protected from other people from viewing unless you enter the password correctly for that worksheet. I then have a main page(Called Home) with 12 Macros on with people's names. When the person clicks on their name it then leads them to their worksheet (the password protected one).

Any ideas on how to go about it and the code needed to make this work? All the sheets and names are in place its just the coding that i'm not sure how to do.

Any help would be appreciated and bear in mind i'm new to this so please be gentle with me :D

Thanks

Andy.